Aggr using excluded fields

Mon, 21 Sep 2015 15:08:59 GMT

Hello,

I have the following expression, which is working fine.

avg(aggr(sum({<Quarter= {$(=Max(Quarter)), $(=Max(Quarter)-1), $(=Max(Quarter)-2), $(=Max(Quarter)-3)}>}Sales), Product, Quarter, Customers))

However, I need to build a second one, which still gives me the results aggregated by Product, Quarter and Customersbut I must ignore whatever selection is active in Customers so that I can compare the two sets of results, one related to a specific Customer and one related to the overall average Sales amongst them.

I've tried all the set analysis I could think of but I did't manage to get it to work - when I select values in Customers, the selection applies to the second expression no matter what.

Can somebody please help?

Thank you!

Linda

Re: Aggr using excluded fields

hic — Mon, 21 Sep 2015 15:14:49 GMT

You may need to use a set analysis expression like {$<Customers=>} both in the outer and in the inner aggregation function. E.g.

Avg( {$<Customers=>} Aggr( Sum( {$<Customers=, Quarter= {...} >} Sales ), ... ))

HIC

Re: Aggr using excluded fields

Mon, 21 Sep 2015 15:19:56 GMT

Thank you!

Thank you!!

Thank you!!!

topic Re: Aggr using excluded fields in QlikView

Aggr using excluded fields

Re: Aggr using excluded fields

Re: Aggr using excluded fields