topic Re: Date Issue in QlikView

Date Issue

VishalWaghole — Tue, 31 Dec 2013 12:53:44 GMT

Hi Community,

i have created date by using makedate function, like

LET vDate = makedate(2013,12,31);

after that i am loading this date like

Load Date($(vDate)) as CurDate

AutoGenerate vDate + 0;

But it will give me two different output.

vDate variable giving me result as = 12/31/2013

and

CurrDate giving me result as = 12/30/1899

Why CurrDate returning different output??

-Regards,

Vishal Waghole

Re: Date Issue

Peter_Cammaert — Tue, 31 Dec 2013 12:59:49 GMT

For Date() and AUTOGENERATE, your date 12/31/2013 is a double division that evaluates to something smaller than 1. Date 0 (probably) equals 12/31/1899.

Also when actually using the day number of 12/31/2013 in your autogenerate clause, you will most likely generate thouands of records, all with the same date. IS that what you want, or do you want to use IterNo() or RowNo()?

Peter

Re: Date Issue

Peter_Cammaert — Tue, 31 Dec 2013 13:01:35 GMT

Remember, Dollarsign expansion is actually TEXT substitution.

Peter

Re: Date Issue

rbecher — Tue, 31 Dec 2013 13:03:51 GMT

Hi Vishal,

you need qoutes here:

Load Date(Date#('$(vDate)')) as CurDate

AutoGenerate 1;

- Ralf