topic Re: Where clause with qualified fields is not working in QlikView

Where clause with qualified fields is not working

Tue, 03 May 2016 10:52:42 GMT

I am getting the following error: Error: Field not found - <Date>

QUALIFY *;
GeoLocColSum:
LOAD REGION,
Floor(DATE) as Date,
"TOTAL_REQUESTS",
"PASSED_REQUESTS",
"FAILED_REQUESTS",
ISMAXDATE

Resident GeoLocColSumTemp Where Date>$(vMaxDate);

It is showing the same error even if I use Where GeoLocColSum.Date>$(vMaxDate);

I think this is because of Qualify.

Your help is appreciated.

Re: Where clause with qualified fields is not working

oknotsen — Tue, 03 May 2016 12:41:00 GMT

Based on your preceding load, the "date" field is called "DATE" not "Date", so change the where clause to this:

Where DATE >$(vMaxDate);

Re: Where clause with qualified fields is not working

sunny_talwar — Tue, 03 May 2016 16:00:28 GMT

Try not to create duplicate threads

Where clause with qualified fields is not working