topic Re: set analysis and the AGGR() function question in QlikView

set analysis and the AGGR() function question

wizardo — Wed, 22 May 2013 08:52:01 GMT

Hi,

sometimes when i use the aggr() function inside and expression (ie to get sum of rows in a pivot table)

i get confused where to put the set analysis expression

for example

let say i have this expression:

avg(aggr(sum(sales),DimA,DimB)))

i want to put a set analysis expression like {<DimC={1}>}

but where do i put it

in the internal sum() on the aggr() or on the external avg()

what is the result in each case?

what is the order of evaluation?

Mansyno

RedSky001 — Wed, 22 May 2013 11:25:05 GMT

Hi Mansyno,

See my attached file with comments, let me know if this helps answer your question.

yvesqlik — Wed, 22 May 2013 12:12:44 GMT

i think that, you have the put the set analysis int avg() and sum() function:

avg({<DimC={1}>} aggr( sum({<DimC={1}>} sales),DimA,DimB))