Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sakamsureshbabu
Creator
Creator

calender

i need calender that to starting and end date selection

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

2 Replies
its_anandrjs

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
Creator
Creator
Author

i wiil try