topic load date values and max(date) as columns in editscript gives Invalid expression? in QlikView

load date values and max(date) as columns in editscript gives Invalid expression?

vinay1233 — Tue, 12 Jun 2018 05:15:57 GMT

error description:Invalid expression

ProductDates:

LOAD

Max(Dates))as MaxDate,

Dates as allDates

FROM

[..\Data Files\Excel\ProducSoldDates.xlsx]

(ooxml, embedded labels, table is Sheet1);

Cant we define script in this way, why is it failing to load as columns?

Re: load date values and max(date) as columns in editscript gives Invalid expression?

sunny_talwar — Tue, 12 Jun 2018 16:09:04 GMT

Try this

ProductDates:

LOAD Dates as allDates

FROM

[..\Data Files\Excel\ProducSoldDates.xlsx]

(ooxml, embedded labels, table is Sheet1);

Join (ProductDates)

LOAD Max(Dates) as MaxDate

Resident ProductDates;

Re: load date values and max(date) as columns in editscript gives Invalid expression?

vinay1233 — Wed, 13 Jun 2018 09:42:29 GMT

thanks, can you explain the actual problem?

Re: load date values and max(date) as columns in editscript gives Invalid expression?

sunny_talwar — Wed, 13 Jun 2018 11:07:06 GMT

You cannot load Max(Dates) and Dates in a same table... because when you use an aggregation function such as Sum, Max, Min... etc... you need a Group By statement which include non-aggregating fields.... if you add Group By Dates... then Max(Dates) will essentially show the same Date for each Date

That is why you need to divide it into two pieces....

Does that make sense?