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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Yi0ta4
Contributor II
Contributor II

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