topic how to assign value in variable using trigger in QlikView

how to assign value in variable using trigger

Fri, 29 Oct 2010 15:01:31 GMT

Hi All

This is Deepak, i have 6 month Exp in QlikView, i have got stuck in one task.

I have 5 Sheet in my Qlikview app,

I have a Multi Box, field Date , where only one date is selected

I want to assign Multi Box, field Date value to one of variable using OnLeavesheet Trigger

It would be helpful for me, if anyone let me know this

Thanks you

how to assign value in variable using trigger

Fri, 29 Oct 2010 16:50:12 GMT

Go to Sheet Properties and add a Trigger to OnLeaveSheet. For the Trigger, you need External>Set Variable. Then add the Variable Name and for Value, =Only(Date).

I've attached a quick sample. In my sample, I use Customer instead of Date. The Trigger is when leaving Main.

Since you're using Only, there needs to be one and only one value selected in Date. If nothing is selected or more than one value is selected, it will probably set the variable to null.