topic Re: Invalid Expression :( in QlikView

Invalid Expression :(

pascos88 — Fri, 08 Jan 2016 09:21:27 GMT

Directory;

LOAD ID,

Nome,

Cognome,

Max(Cell) as MaxC

FROM

MappingLoad.xlsx

(ooxml, embedded labels, table is Foglio1)

Group By Cell;

Someone can see the error in this expression?

Regards

Pasquale

tamilarasu — Fri, 08 Jan 2016 09:23:58 GMT

Hi Pasquale,

Try,

Directory;

LOAD ID,

Nome,

Cognome,

Max(Cell) as MaxC

FROM

MappingLoad.xlsx

(ooxml, embedded labels, table is Foglio1)

Group By ID, Nome, Cognome;

All non-aggregated fields must be in a group by clause.

sunny_talwar — Fri, 08 Jan 2016 09:24:09 GMT

You need to group by fields which are not aggregating. Try this:

LOAD ID,

Nome,

Cognome,

Max(Cell) as MaxC

FROM

MappingLoad.xlsx

(ooxml, embedded labels, table is Foglio1)

Group By ID, Name, Cognome;