3 Replies Latest reply: Dec 19, 2016 11:12 PM by Tamil arasu RSS

    How do I make the date selection automatic?

    Josephinet Tedesco

      Hi All

      at present I have this as for my data load


      LET vDateMin = Num(MakeDate(2016,07,01));

      LET vDateMax = Num(MakeDate(2017,02,01));


      However my SQL says:

      greater than (Current Timestamp -5 months) and less than (Current Timestamp + 2 months)


      I want to automate the Qlikview document so that it does the same thing as the SQL.  At present I manually change the vDateMin and vDateMax at the end of every month.


      Is there a way that I can make vDateMin and vDateMax automatically?




      Thank you