Doing Sum according to one Parameter

Wed, 26 Aug 2015 14:19:02 GMT

Hello Everyone,

I have a table with this kind of data:

Quantity	Parameter
8	X1
9	X2
2	X1
8	X3
8	X3

This is just a few entries but my table is really huge.

I would like to SUM all the quantities for each DISTINCT parameter and then to do Average Min and Max from this Sum.
for example in this situation I want my formula to calculate that :

X1= 10 , X2= 9, X3=16

Then I want a formula that would calculate the average : (10 + 9 + 16 ) / 3

The min would give: 9

And Max: 16

Do you know any way of doing it?
Thank you very much

Re: Doing Sum according to one Parameter

marcus_sommer — Wed, 26 Aug 2015 14:43:17 GMT

I'm not sure if I understand your question right, but try:

avg(aggr(sum(Quantity), Parameter))

min(aggr(sum(Quantity), Parameter))

max(aggr(sum(Quantity), Parameter))

- Marcus

topic Doing Sum according to one Parameter in QlikView

Doing Sum according to one Parameter

Re: Doing Sum according to one Parameter