topic Re: master Calender in QlikView

master Calender

Mon, 02 Jun 2014 06:36:31 GMT

Hi,

I Have 3 Date fields Like CreatDate, DocDate, PstDate

All are representing the same month, date and year (Like 01/04/2014 to 30/04/2014but different value i want to create master calender

how can i

Re: master Calender

amit_saini — Mon, 02 Jun 2014 06:41:44 GMT

Hi,

Call these fields by a single name for example here in this case i m considering name as Datefield.

You this scrip for master calender:

LET vMinDate = num(makedate(2005));

LET vMaxDate = num(today());

Datefield:

LOAD

$(vMinDate) + IterNo() -1 as Datefield

AUTOGENERATE (1)

WHILE $(vMinDate) + IterNo() -1 <= $(vMaxDate);

Calendar:

LOAD

Datefield as %Date,

date(Datefield) as Date,

year(Datefield) as Year,

month(Datefield) as Month,

day(Datefield) as Day,

week(Datefield) as Week,

weekday(Datefield) as Weekday

RESIDENT Datefield;

drop table Datefield;

Thanks,

Re: master Calender

ashfaq_haseeb — Mon, 02 Jun 2014 06:46:48 GMT

go through the below post

http://community.qlik.com/docs/DOC-6502

http://community.qlik.com/docs/DOC-5834

http://community.qlik.com/blogs/qlikviewdesignblog/2014/02/17/canonical-date

Regards

ASHFAQ

Re: master Calender

jagan — Mon, 02 Jun 2014 06:56:01 GMT

Hi,

For this scenario try Canonical Date from this thread

http://community.qlik.com/blogs/qlikviewdesignblog/2014/02/17/canonical-date

Regards,

Jagan.

Re: master Calender

Mon, 02 Jun 2014 06:56:12 GMT

It is working

Thanks You For your Help.