topic Re: How do I make the date selection automatic? in QlikView

How do I make the date selection automatic?

josephinetedesc — Tue, 20 Dec 2016 00:08:54 GMT

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

Re: How do I make the date selection automatic?

tamilarasu — Tue, 20 Dec 2016 01:39:37 GMT

Hi Jo,

LET vDateMin =Num(Monthstart(Addmonths(Today(),-5)));
LET vDateMax =Num(Monthstart(Addmonths(Today(),2)));

Re: How do I make the date selection automatic?

josephinetedesc — Tue, 20 Dec 2016 03:12:26 GMT

Thank you Tamil

Re: How do I make the date selection automatic?

tamilarasu — Tue, 20 Dec 2016 04:12:09 GMT

No problem Jo. Have a good day.