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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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 (1)
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