Download Set Analysis Primer

x

Cyclic Dimension Group in Qlik Sense

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

 

 

If you enjoyed this article, get email updates (it’s free).

* indicates required
About the author

4 Responses
  1. Sara

    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…

  2. Sara

    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!

  3. Analytics Hub

    Yes, change the variable expression:

    =pick(match(if(len(‘$(vCyclicValue)’)>0, ‘$(vCyclicValue)’, ‘CustomerCountry’), ‘Customer Name’, ‘CustomerCountry’, ‘CategoryName’), ‘Customer’, ‘Country’, ‘Category’)

Leave a Reply