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

    How do I make the date selection automatic?

    Jo 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

      Jo