topic Re: Field not Found in QlikView

Field not Found

sibusiso90 — Thu, 12 May 2016 19:21:19 GMT

Field not found - <<=>

I got that error and I don't know what is the cause and an alternative way to do this?

oknotsen — Thu, 12 May 2016 19:27:09 GMT

Can you also post the part in which you define the variables varMinDate and varMaxData?

And yes, it can be done different and I always do it different:

TempCalendar:

Load

Date($(varMinDate) + RowNo() -1) AS TempDate

AUTOGENERATE $(varMaxDate) - $(varMinDate) + 1;

Still might not fix your problem though, as I think that is in the part where you set your variables. I assume a typo or something.

sibusiso90 — Thu, 12 May 2016 19:40:01 GMT

the Period field was a string function, with the format YYYYMM so was just changing it to date field.

tamilarasu — Thu, 12 May 2016 23:59:27 GMT

Hi Sibusiso,

Try like below,

Temp:

Load

Min(Date#(Period & '01', 'YYYYMMDD')) As minDate,

Max(Date#(Period &'01', 'YYYYMMDD')) As maxDate

Resident [Flight Data]

sunny_talwar — Fri, 13 May 2016 02:25:50 GMT

Not sure if Day is really needed, this should work also:

Temp:

LOAD Min(Date#(Period, 'YYYYMM')) As minDate,

Max(Date#(Period, 'YYYYMM')) As maxDate

Resident [Flight Data];

LET varMinDate = Peek('minDate', 0, 'Temp');

LET varMaxDate = Peek('maxDate', 0, 'Temp');

tamilarasu — Fri, 13 May 2016 02:29:51 GMT

Yes. It's not required. I just added for better understanding!!

oknotsen — Fri, 13 May 2016 13:28:06 GMT

I suggest you add a TRACE to check the content of those variables. If the content is something weird or null, you have your source of the trouble.

TRACE Variable varMinDate is $(varMindDate);