Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to assign value in variable using trigger

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

1 Reply
Not applicable
Author

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.