Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All!
I have to make a cyclic dimension-like solution at a table (Qlik Sense 1.1).
I have downloaded an extension (Variable Button), with I am able to make a cyclic dimension.
If I add a drill-down dimension to the table, I'll get the function as a label.
The drill down hierarchy:
level 1: if($(var)=1,'A dimension','B dimension')
level 2: if($(var)=1,'Aa dimension','Bb dimension')
The label become e.g. : if($(var)=1,'A dimension','B dimension').
As far as I know there isn't solution for the mentioned problem, I'm curios do you suggest any workaround for cyclic dimension in Qlik Sense (as far I didn't find any solution, that fits).
Thank you!
G.
Hi,
Create Single Dimension in master item section, using below functions(one for level 1 and one for level 2) and in label expression give name as level 1 & level 2 OR name of your choice. It will reflect in drill down group too.
level 1: if($(var)=1,'A dimension','B dimension')
level 2: if($(var)=1,'Aa dimension','Bb dimension')