topic Re: Master Calender in QlikView

Master Calender

rash_611 — Mon, 17 Feb 2014 04:07:45 GMT

Hi,

I want to create a master calender where the date range is as below.

Jan 26 to Feb 25 ---- Jan Calender

Feb 26 to Mar 25 ---- Feb Calender

Mar 26 to Apr 25 ---- Mar Calender

Can any one help me on this....

Regards,

Grace

Alejandro_Hernández — Mon, 17 Feb 2014 05:33:24 GMT

is this what you need?

set DateFormat='M/D/YYYY';

Let vStart = date('12/31/2013');

Let vEnd = date('12/31/2014');

Load Month(Date) as MonthName, date(Date+25) as Date ;

Load Date('$(vStart)' + RecNo()) as Date autogenerate '$(vEnd)' - '$(vStart)' ;

Mon, 17 Feb 2014 05:46:57 GMT

i think u can use MakeDate function

for a Creating date

makedate(1999,2,14) returns 1999-02-14

jagan — Mon, 17 Feb 2014 05:56:48 GMT

Hi,

Try this

Let vStart = date('1/26/2014');

Let vEnd = date('4/25/2014');

Calendar:

Load

If(Date >= Date('1/26/2014') AND Date <= Date('2/25/2014'), 'Jan',

If(Date >= Date('2/26/2014') AND Date <= Date('3/25/2014'), 'Feb',

If(Date >= Date('3/26/2014') AND Date <= Date('2/25/2014'), 'Mar', Month(Date))) AS MonthName,

Date ;

Load

Date('$(vStart)' + Iterno() - 1) as Date

autogenerate '$(vEnd)' - '$(vStart)' ;

Regards,

Jagan.