topic QlikView Developer Training book AGGR function question in QlikView

QlikView Developer Training book AGGR function question

jblomqvist — Fri, 01 May 2015 15:51:31 GMT

Hello I read the developer book on aggr function.

In one expression you have: max(aggr(sum(LineSalesAmount), CategoryName, ProductName))

Why do you need to dimensions (category and product) when the expression gives the same result with only product field specified?

I get the same result if I just do: max(aggr(sum(LineSalesAmount), ProductName))

Please explain.

Re: QlikView Developer Training book AGGR function question

maxgro — Fri, 01 May 2015 16:38:45 GMT

you can get the same result but not always

Re: QlikView Developer Training book AGGR function question

Anonymous — Thu, 09 Jul 2015 18:02:06 GMT

i agree with Massimo. And to add one more point,in your chart if you do not have dimension category this expression holds good max(aggr(sum(LineSalesAmount), ProductName))..

But in the chart if you have dimensions both ProductName & CategoryName-- then we have to use max(aggr(sum(LineSalesAmount), CategoryName, ProductName))

because aggregate function works only when you list all the diemensions present in the chart.