Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
QlikBeginner1
Creator
Creator

Drop down to select dimension and measure

Hello,

I have a customisable report that I have built. You can select Dimensions and Measures and the report will generate doing a mismatch of the dimensions and measures based off a specific source system.

I wanted to create a dropdown where the user can select specific requirements they want to do comparisons off, instead of manually having to select the dimensions and measures. 

I have created a dropdown, however I am not sure the code on selection of Dimension and Measure based off the dropdown selection? Any help would be greatly appreciated, Please see screenshot below, an example where I have selected Premium Mismatch and the Policy Number and GWP is selected?

Thanks all!

QlikBeginner1_0-1606127205136.png

 

Labels (2)
1 Reply
andykrst
Contributor III
Contributor III

hii,,

to achieve this , maybe you can generate a mapping table in load script that make some relationship between View and dimension and measure fields