Master Calendar Question

Wed, 25 Nov 2020 16:16:04 GMT

Simple Question

Using an excel data file.

Inserted master calendar. I want to create to separate Straight tables using the same data but different views. I have highlighted the section where I have a questions. I need to use two different date fields for the straight tables.

Current Script:

MinMax:
LOAD
Min([Actual Closed Date]) as MinDate,
Max([Actual Closed Date]) as MaxDate
Resident PIPELINEDATA;

Let vMaxDate = Num(Peek('MaxDate',0,'MinDate'));
Let vMinDate = Num(Peek('MinDate', 0, 'MaxDate'));
Let vToday = $(vMaxDate);
Let vRealToday = num(today());

//******** Temp Calendar********
TempCal:
LOAD
date($(vMinDate) + RowNo() - 1) as TempDate
AutoGenerate
$(vMaxDate) - $(vMinDate) + 1;

DROP Table MinMax;

//**********Master Calender************
MasterCalendar:
LOAD
//TempDate as OrderDate,
TempDate as DateIn,
Week(TempDate) as Week,
Year(TempDate) as Year,
Month(TempDate) as Month,
Day(TempDate) as Day,
Weekday(TempDate) as Weekday,
'Q' & ceil(Month(TempDate) / 3) as Quarter,
Date(MonthStart(TempDate), 'MMM-YYYY') as MonthYear,
//Week(TempDate)&'-'&Year(TempDate) as WeekYear,
Year(TempDate)&'-'&Week(TempDate) as WeekYear,
inyeartodate(TempDate, $(vRealToday), 0) * -1 as CurYTDFlag,
inyeartodate(TempDate, $(vRealToday), -1) * -1 as LastYTDFlag
Resident TempCal
Order By TempDate ASC;

DROP Table TempCal;

Re: Master Calendar Question

maheshkuttappa — Wed, 20 Jul 2016 21:46:43 GMT

Do you mean you have two different date fields ? what result are you looking at ?

Re: Master Calendar Question

Wed, 20 Jul 2016 21:49:11 GMT

Meaning in my data I have a 'date closed' and I have a 'projected close date' they are not mutually exclusive and therefore I will need to separate results

Re: Master Calendar Question

maheshkuttappa — Thu, 21 Jul 2016 18:47:33 GMT

You create two Master calendar 'projected close date' and for 'Date close date' or have link table and use set analysis to show the values

Check this , if you have not already done

Canonical Date

topic Re: Master Calendar Question in QlikView

Master Calendar Question

Re: Master Calendar Question

Re: Master Calendar Question

Re: Master Calendar Question