topic Re: Variable Event Trigger not working in QlikView

Variable Event Trigger not working

Thu, 19 Dec 2013 06:46:56 GMT

Hi, I have set two variables (vEnd_unformatted and vStart_unformatted) in a file and have set Variable event triggers for both. For some reason, when I change the value of variable through calendar object, the trigger is not working. Another interesting thing I noticed is when I reload the file right after opening it trigger is working but not subsequently. I appreciate any help on this.

Re: Variable Event Trigger not working

Gysbert_Wassenaar — Thu, 19 Dec 2013 07:04:56 GMT

Format the variables as timestamps and it should work:

='>=' & timestamp($(vStart_unformatted)) & '<=' & timestamp($(vEnd_unformatted))

Re: Variable Event Trigger not working

jvishnuram — Thu, 19 Dec 2013 07:05:13 GMT

Hi Ankit,

Your data model only have 3 date points so see the attachment hope it will helps you.

Re: Variable Event Trigger not working

Thu, 19 Dec 2013 07:13:34 GMT

Thank you for quick reply. You are the saver.

Re: Variable Event Trigger not working

Thu, 19 Dec 2013 07:18:38 GMT

Vishnu, Thank you for your help.

Re: Variable Event Trigger not working

Thu, 19 Dec 2013 07:22:45 GMT

Just out of curosity, why do we need "$" before variable ?

Re: Variable Event Trigger not working

Nicole-Smith — Thu, 19 Dec 2013 19:43:39 GMT

For your data, you don't need the "$" before the variable because it contains a number. However, if your variable contained a calculation that needed to be done, you would need the "$" for dollar-sign expansion in order to do the calculation.

Search for dollar-sign expansion in QV help to learn more: