Qliksense Master Calender

[abhaysingh]

hi all,

i have Order Table

Order

OrderDate

OrderId

From... Path

Temp:

load   min(OrderID) as MinDate;

  max(OrderID) as MaxDate;

Resident Order;

let vMinDate = num(peek('MinDate',0,'Temp');

     vMaxDate= num(peek('MaxDate',0,'Temp');

TempCalender:                                                                           /// Giving me error in Qliksense Field not found - <<=>: TempCalender: LOAD Date(+RecNo()-1)as TempDate AutoGenerate 1 while + IterNo()-1 <=  //  but working fine in qlikview

               $(vMinDate) +Iterno()-1 as num,

               Date($(vMinDate) +iterno()-1) as TempDate,

               autogenerate 1 while $(vMinDate)  + iterno()-1 <= $(vMaxDate);

Mastercalender:

date(TempDate) as Date,

Year(TempDate) as Year

resident TempCalender;

[sunny_talwar]

You need to use OrderDate instead of OrderID here:

Temp:

load   min(OrderID) as MinDate;

  max(OrderID) as MaxDate;

Resident Order;

[Gysbert_Wassenaar]

let vMinDate = num(peek('MinDate',0,'Temp');

     vMaxDate= num(peek('MaxDate',0,'Temp');

That doesn't look right either. The closing parentheses of the num functions are missing and the second line is missing a LET.

[sunny_talwar]

And to link it to your order table you need to use the same field name for date in your master calendar

Mastercalender:

date(TempDate) as Date OrderDate,

Year(TempDate) as Year

resident TempCalender;

[bismart]

Temp:

load   min(OrderDate) as MinDate;

  max(OrderDate) as MaxDate;

Resident Order;

[Michael_Tarallo]

Hello Abhay,

Please check out this video and let me know if it helps.

Understanding the Master Calendar (video) and samples

Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.

Regards,

Mike Tarallo

Qlik