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 Yi0ta4_0-1648831029068.png](https://community.qlik.com/t5/image/serverpage/image-id/75991iB98A52C66172FBA5/image-size/medium?v=v2&px=400)
My metrics are set up like this:
![Yi0ta4_1-1648831497766.png Yi0ta4_1-1648831497766.png](https://community.qlik.com/t5/image/serverpage/image-id/75992i0063AEA58FB9C007/image-size/medium?v=v2&px=400)
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, '|')&')' )