topic Re: Date Compare in QlikView

Date Compare

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I guys, I have this line of code:

Load

max(Data) as maxDate

Resident Calendar ;

Let vMaxDate = Date($(varMaxDate));

DROP Table Temp;

Table:

LOAD id

MakeDate(year, month, day) as DateTb,

effort

FROM

[path ...]

(ooxml, embedded labels, table is xtmp);

TableDate:

LOAD *

Resident Table

where DateTb > $(vMaxDate);

The last part of the script (TableDate) doesn't work, and load all date.

Someone can tell me why the "where" clause doesn't work?

Thanks

trdandamudi — Fri, 01 Dec 2017 15:27:10 GMT

May be the where condition is as below:

where DateTb > $('vMaxDate'); <-- see the single quote within the bracket

Anonymous — Fri, 01 Dec 2017 16:38:00 GMT

where DateTb > $('vMaxDate');

Are the fields in the same format??

sunny_talwar — Fri, 01 Dec 2017 16:47:17 GMT

How do you define varMaxDate?

Anonymous — Mon, 04 Dec 2017 15:36:22 GMT

Hi guys, I resolved in this way:

Where Date(DateTb) > '$(vMaxDate)';