topic Invalid Expression using max and group by in QlikView

Invalid Expression using max and group by

Mike_Solfosko — Mon, 27 Apr 2020 15:52:23 GMT

Hi everyone,

I'm having some issues with my script.

If someone could help me I would really appreciate.

Shop:
NoConcatenate
LOAD
distinct name_shop,
Address,
City,
Sales
FROM [lib://DataFiles/shop.csv]
(txt, utf8, embedded labels, delimiter is ';', msq);

Temp:
LOAD
distinct name_shop,
Address,
City,
max(Sales) as max_sales
resident shop

Group By name_shop;

Re: Invalid Expression using max and group by

kaushiknsolanki — Mon, 27 Apr 2020 16:12:29 GMT

Hi,

You should add few more fields in group by statement of yours.

Temp:
LOAD
name_shop,
Address,
City,
max(Sales) as max_sales
resident shop

Group By name_shop,Address,City;

Re: Invalid Expression using max and group by

Mike_Solfosko — Tue, 28 Apr 2020 02:41:27 GMT

Thank you, it worked perfectly