



Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Community
Ask the community for help and clear up your study doubts
Discover the best universities in your country according to Docsity users
Free resources
Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors
In this document, we explore how to replicate the functionality of Cyclic Groups in Qlik Sense, which is currently not supported. By using the qsVariable extension, we can easily change the context of our analysis within the same chart. a step-by-step guide on how to install the extension, create a variable, and apply it to a chart. This approach allows users to look at the same measure from different perspectives, making it beneficial for certain types of analyses.
What you will learn
Typology: Study Guides, Projects, Research
1 / 6
This page cannot be seen from the preview
Don't miss anything!
Background I’ve seen a lot of questions recently from people with backgrounds in Qlik View identifying some features that they use a lot in View but are currently not supported in QlikSense. In this document I will show you how with the use of an extension you can mimic the behaviour of a Cyclic Group in Sense. What is a Cyclic Group? There are 2 ways of grouping your data into user defined hierarchies in Qlik, Drill down and Cyclic. Drill down allows you to filter down through the hierarchy to find deeper insights. If you had a Product Hierarchy for example with 4 levels: Drill Down allows the user from a high level to go into the next level down filtering your data as you go down to the lowest level of granularity as a result your measure value also reduces as you narrow down your view. You exclude data from your view with each click. Cyclic allows you to look at the same measure but from different points of view. You do not filter data but rather you change the point of view. Drill down is great where you want to know which part numbers are in product A but if you want to know which other products a part number is in you need an additional filter on the side. That is
Group Family Product Part No
where Cyclic groups are beneficial to easily change the context of the question within the same chart. Currently in Qlik Sense you can create Drill Down groups but not cyclically ones. Below is how I manage to mimic the functionality in Sense. What you need?
How to apply your cyclic group in a chart? Create your chart in my case I wanted to see sales from 3 points of view (By Company, By Product and by Month). In the dimension setting of your chart rather than selecting one dimension from your data model or master items add the following: Pick(Match($(
I did the same on the appearance to make the Title dynamic to. Note I used IF statement for my Title setting but Pick and Match for my Dimension selection. They are interchangeable allow Pick and Match is better from a performance perspective. So in my example I have sales I can now look at by Month by Company