Facing error message in Master calendar ( Qliksense)

vlakeshr — Tue, 18 Sep 2018 11:52:06 GMT

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....

topic Facing error message in Master calendar ( Qliksense) in QlikView

Facing error message in Master calendar ( Qliksense)