QlikView developers still miss some of the handy QlikView features in Qlik Sense.
For instance, you can create a cyclic group of dimensions in QlikView, but you can’t in Qlik Sense.
You may argue that an alternative dimension is an indirect solution for the cyclic dimensions in Qlik Sense.
You can add alternate dimensions for each chart, but you can’t create a master item.
Also, you can’t add alternate dimensions to tables in Qlik Sense.
I am sure that many of you are looking for a simple solution to create a cyclic dimension group as a master item in your Qlik Sense application.
Fortunately, I was able to create a cyclic dimension group as a master item along with the magic of a variable and dollar-sign expansion.
It’s a three-step process.
First, create a master dimension with a combination of pick and match functions.
Next, create a variable vCyclicDim using a system field, $Field, which contains all the fields in the table. Use this variable in another using dollar-sign expansion.
Notice the logic for the vCyclicDim to display Customer Country by default until the user selects a value from the cyclic dimension group.
Finally, use a calculated dimension in the table using a dollar-sign expansion.
Now, you can use ‘$(vCyclucDim)’ as a calculated dimension on multiple charts that require a cyclic group.
Become a Pro member and let us help you master QlikView and Qlik Sense!
Become a Pro Member