topic Re: Date Variable in QlikView

Date Variable

danielnevitt — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a script that where I state the following:

where tl.final_pricing_dt > '2016-08-29'

Is it possible to replace the date with a variable for yesterday?

Thanks,

Daniel

sunny_talwar — Wed, 31 Aug 2016 12:31:06 GMT

Sure, may be like this:

LET vDate = Date(MakeDate(2016, 8, 29), 'YYYY-MM-DD');

Where tl.final_pricing_dt > '$(vDate)';

Wed, 31 Aug 2016 12:31:30 GMT

Hi,

vYesterday=Today()-1

Thanks,

Nitin

danielnevitt — Wed, 31 Aug 2016 12:42:17 GMT

Thanks for the reply.

Will that create a moving date? For example if I run the report tomorrow I would like the date to be today.

ie Run on 01/09/2016 and pricing greater than 31/08/2016.

Regards,

Daniel

sunny_talwar — Wed, 31 Aug 2016 12:43:44 GMT

May be this:

LET vDate = Date(Today() - 1, 'YYYY-MM-DD');

Where tl.final_pricing_dt > '$(vDate)';

Wed, 31 Aug 2016 12:51:36 GMT

Yes , Today() function gives you today's date every time you open or reload the qvw .

Thanks

Nitin

Chanty4u — Thu, 01 Sep 2016 11:00:02 GMT

try lik

let vdate=Date(Today()-1,'YYYY-MM-DD');

[test]:

LOAD * INLINE [

Maand, ID, myDate

1, 2, 2014-12-14

2, 3,2016-09-15

]

Where myDate>'$(vdate)';