Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download 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