Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have two columns as Start date and End date in my data. I want to connect my data with calendar. how to join calendar with this data so as to connect calendar with both start and End date.
Thanks,
Piyush Jain
Have a look at Canonical dates:
Qlik Design Blog : Canonical Date | Qlik Community
Linking to two or more dates | Qlik Community
Peter
hi jain. this is very simple example that helps you to understand this issue (with only working days)
try this code:
let vStartDay = date('01/01/2010');
let vEndDate = date('31/12/2016');
for x = vStartDay to vEndDate
tempCalendar:
load $(x) as Date AutoGenerate(1);
next x
NoConcatenate
Working_Calendar:
Load Date, weekday(Date) as WeekDay, week(Date) as Week, Month(Date) as Month, Year(Date) as Year, floor(month(Date)/3)+1 as Qtr
resident tempCalendar
where WeekDay(Date) <> 'Sat' and WeekDay(Date) <> 'Sun';
drop table tempCalendar;
if you Need more examples to this issue. so let me know
beck
You can use intervalMatch:
or use While loop to expand start to end dates into a date field: