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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
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?