topic Re: Invalid expression in QlikView

?

xyz1 — Sun, 14 Apr 2019 16:29:39 GMT

tresB — Wed, 03 Jan 2018 09:08:39 GMT

Missing Group By clause may be?

Anil_Babu_Samineni — Wed, 03 Jan 2018 09:08:49 GMT

Avg should need Group By. Without that it won't work for aggregate functions like Sum, Avg, Count ... in script

jhoef-pv — Wed, 03 Jan 2018 14:35:01 GMT

Hi Agrim,
Avg need group by

for example:

table:

load

field_1,

if(((Avg([Rating #])))='1', 'a', if(((Avg([Rating #])))=2, 'b')) as classification

from table.xls

group by field_1;