topic Re: set variable on active selection in QlikView

set variable on active selection

Thu, 17 Oct 2013 10:20:02 GMT

Hi all,

i need help with a script.

I have a List Box like this : A

and a variable vshowChart.

So when i select for example value 'A' i need variable set to '1', when 'B' variable set to '0'

Can u help me pls?

Tyvm

Re: set variable on active selection

tresB — Thu, 17 Oct 2013 10:26:09 GMT

PFA, used field event trigger

Re: set variable on active selection

Gysbert_Wassenaar — Thu, 17 Oct 2013 10:28:01 GMT

Add an action to the OnSelect field trigger of the field in your listbox (Look on the Triggers tab of the document properties window). Choose External and then Set Variable to get the right action. Set the variable name to vShowChart and use this expression: =if(MyField='A',1,0). Replace MyField with the name of the field of the listbox.

Re: set variable on active selection

sushil353 — Thu, 17 Oct 2013 10:28:15 GMT

lets say your listbox field name is F1

then use

=vVariable=if(getfieldselections(F1)='A',1,0)

HTH

Sushil