topic Re: creating a calendar in QlikView

creating a calendar

Thu, 14 Mar 2013 11:14:35 GMT

Hi,

Am using the below script to create a calendar starting from 01/01/2012.

it works fine but it also gives future dates.

I just want to display starting from 2012 to till date.

what changes are to be made?

LOAD date(makedate(year(today())-1)-1+RecNo(),'MM-DD-YYYY') as [Link Date]

AUTOGENERATE (makedate(year(today())+1) - makedate(year(today())-1));

thanks in advance

sujay

Thu, 14 Mar 2013 11:23:00 GMT

Hi,

Can you please attach your apllication.

Thu, 14 Mar 2013 11:27:29 GMT

Hi nirmal

i just want to create a calender from 01/01/2012 to till date.

this i am doing in the script of a qvd maker.

Later i am going to derive number of fields from [link date]

MEllinghausen — Thu, 14 Mar 2013 11:30:23 GMT

AUTOGENERATE(date((today())) -yearstart(YearStart(Today())-1))

Marcus

er_mohit — Thu, 14 Mar 2013 11:45:42 GMT

LET vDateMin = Num(MakeDate(2012,1,1));

LET vDateMax = Num(Today());

TempCalendar:

LOAD

$(vDateMin) + RowNo() - 1 AS DateNumber,

Date($(vDateMin) + RowNo() - 1) AS datefield

AUTOGENERATE 1

WHILE $(vDateMin)+IterNo()-1<= $(vDateMax);

hope it helps

Thu, 14 Mar 2013 12:04:48 GMT

Hi marcus

thanks for the reply.

everythings fine but its not giving 01/01/2012

i mean calender starts from 01/02/2012.

Jan 1st of 2012 is missing.

any suggestions?

sujay

Thu, 14 Mar 2013 12:20:31 GMT

solved.