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.
Naah!
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
Hi,
Thanks for the post.
I could not figure out where/how you use the master item created in the first step.
Would appreciate your help…
Sorry, guys, I figured the answer for the master item Cyclic Dimension.
One more question:
I see that the label in the table shows the field name and not the string defined in the Pick expression.
Can it be fixed?
Thanks!
Yes, change the variable expression:
=pick(match(if(len(‘$(vCyclicValue)’)>0, ‘$(vCyclicValue)’, ‘CustomerCountry’), ‘Customer Name’, ‘CustomerCountry’, ‘CategoryName’), ‘Customer’, ‘Country’, ‘Category’)
Very helpful post. Thank you.
Can we create one more cyclic group in the same app? When i create two, both mix up.? Do you have a work around?