Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

abhaysingh
Contributor III

Qliksense Master Calender

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;

5 Replies
MVP
MVP

Re: Qliksense Master Calender

You need to use OrderDate instead of OrderID here:

Temp:

load   min(OrderID) as MinDate;

  max(OrderID) as MaxDate;

Resident Order;

Re: Qliksense Master Calender

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.

MVP
MVP

Re: Qliksense Master Calender

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
Contributor

Re: Qliksense Master Calender

Temp:

load   min(OrderDate) as MinDate;

  max(OrderDate) as MaxDate;

Resident Order;

Employee
Employee

Re: Qliksense Master Calender

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