topic Re: format problem in QlikView

format problem

Tue, 13 Mar 2012 12:18:02 GMT

Hi all,

in my script i generate a calendar:

Load

Date(Date#('1/1/2008','D/M/YYYY')+RowNo()-1) as Date_,

Year(Date#('1/1/2008','D/M/YYYY')+RowNo()-1) & Num(Month(Date#('1/1/2008','D/M/YYYY')+RowNo()-1), '00') as M_,

WeekDay(Date#('1/1/2008','D/M/YYYY')+RowNo()-1) as WeekDay_

AutoGenerate

Interval(Date#('31/12/2015','D/M/YYYY')-Date#('1/1/2008','D/M/YYYY'),'D');

The problem is that i need:

Year(Date#('1/1/2008','D/M/YYYY')+RowNo()-1) & Num(Month(Date#('1/1/2008','D/M/YYYY')+RowNo()-1), '00') as M_,

to be in a real date format YYYYMM instead of a concatenated number.

Can someone help me formatting this ?

Thanks a lot!

swuehl — Tue, 13 Mar 2012 12:21:55 GMT

Maybe like

Date(Date#('1/1/2008','D/M/YYYY')+RowNo()-1),'YYYYMM') as M_,

Tue, 13 Mar 2012 12:25:51 GMT

Something seems to be not right with the ) after the 'YYYYmMM'

CELAMBARASAN — Tue, 13 Mar 2012 12:44:39 GMT

Hi,

Try with this

Date((Date#('1/1/2008','D/M/YYYY')+RowNo()-1),'YYYYMM') as M_

instead of

Year(Date#('1/1/2008','D/M/YYYY')+RowNo()-1) & Num(Month(Date#('1/1/2008','D/M/YYYY')+RowNo()-1), '00') as M_,

Celambarasan

swuehl — Tue, 13 Mar 2012 13:23:30 GMT

Yes, one ')' too many:

=Date(Date#('1/1/2008','D/M/YYYY')+RowNo()-1,'YYYYMM') as M_,