2 Replies Latest reply: Jul 13, 2016 3:56 AM by Tamara Witzgall RSS

    Reset variables at midnight

    Tamara Witzgall

      Hi,

       

      I have a QlikView application which I reload at 1 a.m. every day. Sometimes it may be necassary to reload it during the day to get new data.

      I want to trigger a different code if it is not the first reload on that day - so I need something like that:

       

      11.07.2016

      Midnight:   vReloadTimesToday = 0

      1st reload at 1 a.m. results in vReloadTimesToday = 1

      reload at 3 p.m. results in vReloadTimesToday = 2

       

      12.07.2016

      Midnight:   vReloadTimesToday = 0

      1st reload at 1 a.m. results in vReloadTimesToday = 1

       

      Is there a way to "reset" the value of the variable at midnight?

       

      Thanks for your input.

      Regards

      Tamara