Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

sakamsureshbabu
Contributor

calender

i need calender that to starting and end date selection

how can i use it.......

2 Replies

Re: calender

Hi,

Try like

Let vMinDate = NUM(Date#('08/12/2005','DD/MM/YYYY'));

Let vMaxDate = NUM(Date#('30/06/2006','DD/MM/YYYY'));

TempDateTable:

LOAD

date($(vMinDate)+IterNo()-1) AS TempDate

AutoGenerate 1

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

MasterCalendar:

LOAD

TempDate,

Month(Floor(TempDatefield)) AS Floordate,

Year(date(TempDatefield)) as Year,

Month(date(TempDatefield)) as Month,

Day(date(TempDatefield)) as Day,

Time(date(TempDatefield)) as Time,

Week(date(TempDatefield)) as Week

Resident TempDateTable;

Regards

Anand

sakamsureshbabu
Contributor

Re: calender

i wiil try

Community Browser