Automatic list box selection based on another selection

Yi0ta4 — Fri, 01 Apr 2022 16:47:39 GMT

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.

My metrics are set up like this:

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, '|')&')' )

topic Automatic list box selection based on another selection in QlikView