Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Facing error message in Master calendar as
"
The following error occurred:
Field 'a' not found
"
Below is my master calendar script ----
Calendar :
[Analyzer Dates]:
LOAD
%DATE_KEY
Resident ZCFM_MC5;
//
Temp:
Load
min(%DATE_KEY) as minDate,
max(%DATE_KEY) as maxDate
Resident [Analyzer Dates];
Drop Table [Analyzer Dates];
Let varMinDate = Num(Peek('minDate', 0, 'Temp'));
Let varMaxDate = Num(Peek('maxDate', 0, 'Temp'));
DROP Table Temp;
TempCalendar:
LOAD
$(varMinDate) + Iterno()-1 As Num,
Date(($(varMinDate) + IterNo() - 1),'DD.MM.YYYY') as TempDate
AutoGenerate 1 While $(varMinDate) + IterNo() -1 <= $(varMaxDate);
Master_Calender:
Load
Month(TempDate) As Month,
num(Month(TempDate)) as MonthNumber,
'Q' & CEIL(NUM(MONTH(TempDate))/3) AS Quarter,
Year(TempDate) As Year,
week(TempDate) as Week,
TempDate AS %DATE_KEY,
DATE(MONTHSTART(TempDate), 'MMM-YYYY') AS MonthYear
//Date(Month(TempDate)&' '&Year(TempDate),'MMM YYYY') as CalendarMonthAndYear
Resident TempCalendar
Order By TempDate ASC;
Drop Table TempCalendar;
==================================================================================================
I am acing above error message while use this script. I had checked some blogs related the same issue but i am not getting correct date which is available in my data source.
I have referred below blogs:
https://community.qlik.com/thread/119816
according to this blog , I used
Load
(floor(today()+rowno())) as %DATE_KEY,
Resident ZCFM_MC5;
It's working but i am getting date from today onward because "(floor(today()" which was used in script.
I want date according to source data and source data from date 01.01.2017 to till date. but not getting date according to data.
Could you please suggest any new function which can use in script to get the date according to data.
Find the attached screen shot FYR.
Appreciate for quick response....