QlikView App Dev

[#1]

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.

[Gysbert_Wassenaar · Accepted solution]

Format the variables as timestamps and it should work:

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

[jvishnuram]

Hi Ankit,

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

[#4]

Thank you for quick reply. You are the saver.

[#5]

Vishnu, Thank you for your help.

[#6]

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

[Nicole-Smith]

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: