topic Re: Dynamic Date in QlikView

Dynamic Date

Mon, 19 May 2014 08:41:42 GMT

Hi All,

Is there anyway that i can change this expression to automatically calculate 14 days back?

Thanks

Mon, 19 May 2014 08:42:11 GMT

Expression:

let vFromDate=floor(Date#('2014-04-10','YYYY-MM-DD'));

tresB — Mon, 19 May 2014 08:47:58 GMT

Not sure if understood right. May be like:

Let vBackDate=Num(Today()-14); // now you can replace today() with any date. Integer 1 is equivalent to 1 day.

Anonymous — Mon, 19 May 2014 08:48:11 GMT

Here you go

vFromDate=floor(Date#('2014-04-10','YYYY-MM-DD'))-14;

Mon, 19 May 2014 08:48:33 GMT

Never Mind, Figured it Out...

let vFromDate=date(floor(today()-14))

anbu1984 — Mon, 19 May 2014 08:49:05 GMT

Date(floor(Date#('2014-04-10','YYYY-MM-DD'))-14,'YYYY-MM-DD')