topic Re: Master Calendar "Field 'a' not found" Error in QlikView

Master Calendar "Field 'a' not found" Error

aravind_dussani — Tue, 26 Dec 2017 11:02:08 GMT

Hi Community people. I tried to create a master calendar in Qlikview. But i'm getting an error as "Field 'a' not found" when i reload. have a look at my script which i mentioned below.and suggest me corrections.

OrderHeader:

LOAD OrderDate,

OrderID,

ProductID,

Quantity,

Sales,

Discount,

CostOfSales,

GrossProfit,

DeliveryDate

FROM

(ooxml, embedded labels, table is Sheet1);

MinMaxDates:

LOAD

min(OrderDate) as minDate,

max(OrderDate) as maxDate

Resident OrderHeader;

Let vMinDate = Num(Peek(‘minDate’,0,’MinMaxDates’));

Let vMaxDate = Num(Peek(‘maxDate’,0,’MinMaxDates’));

DROP table MinMaxDates;

DateRanges:

Load

$(vMinDate) + IterNo()-1 as DateNum,

Date($(vMinDate) + IterNo()-1) as TempDate

Autogenerate 1 while $(vMinDate) + IterNo()-1 <= $(vMaxDate);

MasterCalender:

load TempDate as OrderDate,

Day(TempDate) as Master.Day,

Week(TempDate) as Master.Week,

Month(TempDate) as Master.Month,

'Q'& Ceil( Month(TempDate)/3) as Master.Quarter,

Year(TempDate) as Master.Year

Resident DateRanges order by TempDate asc;

DROP table DateRanges;

Re: Master Calendar "Field 'a' not found" Error

sunny_talwar — Tue, 26 Dec 2017 17:54:32 GMT

Would you be able to post a screenshot of the error message?

Re: Master Calendar "Field 'a' not found" Error

Anil_Babu_Samineni — Wed, 27 Dec 2017 02:24:37 GMT

Which field is that?

Re: Master Calendar "Field 'a' not found" Error

Chanty4u — Wed, 27 Dec 2017 07:30:12 GMT

share your source file

Re: Master Calendar "Field 'a' not found" Error

luismadriz — Wed, 27 Dec 2017 07:56:37 GMT

Hi,

The only problem I could see was the apostrophes here:

Let vMinDate = Num(Peek(‘minDate’,0,’MinMaxDates’));

Let vMaxDate = Num(Peek(‘maxDate’,0,’MinMaxDates’));

Change it to this:

Let vMinDate = Num(Peek('minDate',0,'MinMaxDates'));

Let vMaxDate = Num(Peek('maxDate',0,'MinMaxDates'));

I hope this helps,

Cheers,

Luis

Re: Master Calendar "Field 'a' not found" Error

luismadriz — Wed, 27 Dec 2017 07:58:51 GMT

Red one is the one you're using, black one is a good one:

Re: Master Calendar "Field 'a' not found" Error

aravind_dussani — Wed, 27 Dec 2017 09:28:03 GMT

@Luis Madriz :: very thanks for ur support.

i changed script according to your suggestion . there is apostrophes problem in my script. n finally got master calender output.

Re: Master Calendar "Field 'a' not found" Error

aravind_dussani — Wed, 27 Dec 2017 09:28:38 GMT

thanks all those responded to this post..