topic Re: How to you always select multiple fields in a list box: Qlikview 12 in QlikView

How to you always select multiple fields in a list box: Qlikview 12

sammie0808 — Wed, 25 Nov 2020 16:16:04 GMT

In qlikview 12 you can go to the list box properties and select "Always one selected value" which works great. I but i need to "always select 2 values" in this list box?

Can anyone please let me know how to do that?

Thanks,

Doug

Re: How to you always select multiple fields in a list box: Qlikview 12

Anil_Babu_Samineni — Sun, 26 Mar 2017 02:31:13 GMT

May be triggers on Document Event Triggers like. Ctrl + Alt + D --> Triggers --> DET --> OnOpen --> Actions --> Add --> Selection --> Select in Field --> Field called(Your field name) --> Search String may be use this ("Value1","Value2")

and then do same process for Lock and then check.

Re: How to you always select multiple fields in a list box: Qlikview 12

maxgro — Sun, 26 Mar 2017 09:25:44 GMT

An example with trigger in the attachment

Use ctrl to change the values in the listbox

Re: How to you always select multiple fields in a list box: Qlikview 12

MarcoWedel — Sun, 26 Mar 2017 21:33:14 GMT

Hi,

one solution might be:

='('&Concat($(=If(GetSelectedCount(Year)>1,'','{$1}')) DISTINCT Year, '|')&')'