Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
HediB
Contributor
Contributor

user selection of dimension with hierarchy

I have exposed my dimension to the end user selection via a table of dimension, and used the selection to dynamically show it in a table (and graph etc ...) This is now working fine, but if I whan to add in the list a hierarchy it doesn't work ...

Here are an example I built to reproduce my problem : 

create a variable : VselectedDimension [Dimension]

load this in the script

VariableDimension :
NoConcatenate
lOAD * inline
[
Dimension, DimensionOrder, DimensionPresentationName

Budget_Hierarchy, 1 , Budget_Hierarchy,
Level0, 2, 'Level 0'
];

 

//Data for test

TestData :
NoConcatenate
lOAD * inline
[
Level0, Level1, Level2, Value
A, AA, AAA,10,
A, AB, ABA,15,
A, AB, ABB,20,
A, AC, ABC,30,
B,AA, AAA,5,
B,AB, ABC,12

];

 

Create a table where field is =$(=$(VSelectedDimension)) and the label is =$(VSelectedDimension)

It works fine for simple dimension, but doesn't work for the hierarchy, any help ? is there a specific way to invoke a hierarchy ....

Thanks for your help and support,

Hedi

Labels (1)
0 Replies