Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Sra1bandi
Contributor III
Contributor III

Feild a not found showing when i am trying to create master calender

Min_Max:
Load
Min("Created Date") as MinDate,
Max("Created Date") as MaxDate
Resident TradeNameRequest;

Let vMinDate = num(Peek('MinDate',0,'Min_Max'));
Let vMaxDate = num(Peek('MaxDate',0,'Min_Max'));
Trace $(vMAxDate);
Drop Table Min_Max;

Dateranges:

Load
$(vMinDate) + IterNo()-1 as datenum,
Date($(vMinDate) + IterNo()-1) as Tempdate
AutoGenerate 1 while $(vMinDate) + IterNo()-1 <= $(vMaxDate);

MasterCalender:

Load
Tempdate as "Created Date",
Date(Tempdate) as Created_Date,
year(Tempdate) as Year,
'Q'&Ceil(Month(Tempdate)/3) as Quarter,
Month(Tempdate) as Month,
Day(Tempdate) as Day,
week(Tempdate) as week

Resident Dateranges Order by Tempdate asc ;

Drop Table Dateranges;

Labels (1)
1 Reply
Vegar
MVP
MVP

Could it be that your Dateranges table never gets created?

Do get the expected output to the Dateranges table?