Emulating cyclic dimension group in Qlik Sense

Current version of Qlik Sense Desktop do not support cyclic dimension groups (drilldown groups are supported).

In this post I illustrate how to emulate this functionality. This method does not employ extensions objects and so on. Basically it uses additionally loaded field in island table and macro expansion in chart dimension. Sample applicaiton is available.

Result looks like that:

Sales by cities

and like that (another dimension selected):

Sales by branches

That solution has some glitches in current version but I think it can be useful if you wish to reduce amount of almost identical sheets in your Qlik Sense application.

Couple of sore points:

Download sample application - you should place it at the directory c:\Users\[User name]\Documents\Qlik\Sense\Apps to check it up.

comments powered by Disqus