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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Yi0ta4
Contributor
Contributor

Automatic list box selection based on another selection

Is it possible to select other fields in a list box automatically? 

I would like to have Budget New Retail and Volume automatically selected if I select B/W Budget New Retail.

Yi0ta4_0-1648831029068.png

My metrics are set up like this:

Yi0ta4_1-1648831497766.png

 

I have tried using Document Properties>Triggers>Field Event Triggers with no success, here is what I tried:

Using _metrics_SR:

=If(_metrics_SR='B/W Budget New Retail', '(B/W Budget New Retail| Volume Retail | Budget New Retail)', '('&Concat(DISTINCT _metrics_SR, '|')&')')

Using _metricsNo_SR:

=If(_metricsNo_SR = 113, '(113|109|80)', '('&Concat(DISTINCT _metricsNo_SR, '|')&')' )

0 Replies