Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, I am trying to create a dropdown list based on list of variable. After finishing all steps, the dropdown didnt show up anything. Could you please help me to figure out what I need to do?
From the data load editor tab, I created 2 variable:
LET vListDimension = 'Gender|Marital_Status|Attribute_Flag|Income_Category';
LET vDimensionSelection = ' ';
After that, I choose
Name: vDimensionSelection
shown as: Drop down
Dynamic
Dynamic value: ='$(vListDimension)'
In QlikView could the input-box for variables contain such a pre-defined or calculated list of values which were per dropdown selectable (no idea if this also available within Sense). But this couldn't be used for dimensions.
If such logic is wanted as dimension within a chart an appropriate field should be generated within the data-model - ideally properly linked with the other data-set. If this isn't possible a loosen table could be used. UI approaches may the use of valuelist() or valueloop() - but they have as calculated dimensions some disadvantages.