aggr for a sum / sum expression

praijmakers — Fri, 14 Sep 2018 13:10:56 GMT

Hello Everybody,

Please take a look at this example table:

Group	SubGroup	Value1	Value2	base expression = sum(Value1)/sum(Value2	Aggr(NoDistinct sum(Value1)/ sum(Value2), Group)	I want
A	A1	2	1	2	2	4
A	A2	4	2	2	2	4
B	B1	6	2	3	3,6	7
B	B2	12	3	4	3,6	7

So what i want is the sum of the results for the base expression per group. But the base expression is a sum() devided by sum() expression so the aggr of that leads to an average. This is a simplified example. The base expression can not be changed.

I tried using an expression label reference like: aggr( sum( [base expression] ), Group) but label references in aggr do not work.

Your help would be much appreciated.

Regards,

Peter

Re: aggr for a sum / sum expression

vishsaggi — Fri, 14 Sep 2018 15:47:44 GMT

Try this?

= Sum(TOTAL <Group> Value1/Value2)

topic aggr for a sum / sum expression in QlikView

aggr for a sum / sum expression

Re: aggr for a sum / sum expression