topic Re: Sum AGGR divided by in QlikView

Sum AGGR divided by

rospigliosi — Thu, 30 Mar 2017 15:05:47 GMT

Hi experts,

on a dynamic straight table, in the column "Dim3 Value" I obtain the following result with "sum(aggr(Value,Dim1,Dim3))"

Dim 1	Dim 2	Dim 3	Dim3 Value
			TOTAL: 140
A	B	E	0
A	B	F	0
A	B	G	0
A	C	E	0
A	C	F	0
A	C	G	0
A	D	E	84
A	D	F	15
A	D	G	41

But I would like to obtain this:

Dim 1	Dim 2	Dim 3	Dim3 Value
			Total: 140
A	B	E	84
A	B	F	15
A	B	G	41
A	C	E	84
A	C	F	15
A	C	G	41
A	D	E	84
A	D	F	15
A	D	G	41

I tried to do this: "sum(aggr(Value,Dim1,Dim3,Dim2))/count (distinct Dim2)", it work only if the DIM1 is only one selected value (in my example the selected value is "A") but if i select more than one DIM1 my qlikview desktop freezes my laptop.

Re: Sum AGGR divided by

Anonymous — Thu, 30 Mar 2017 15:10:10 GMT

Can you provide sample data?? or a sample qvw??

Re: Sum AGGR divided by

vishsaggi — Thu, 30 Mar 2017 15:43:56 GMT

Try this? Else can you share a sample ?

= sum(aggr(Sum(Value), Dim1, Dim2,Dim3)) / count (distinct Dim2)

Re: Sum AGGR divided by

Anonymous — Thu, 30 Mar 2017 15:55:24 GMT

perhaps:

sum(aggr(nodistinct Value,Dim1,Dim3))

sum(total <Dim1,Dim3> value)

Re: Sum AGGR divided by

sunny_talwar — Thu, 30 Mar 2017 15:57:20 GMT

May be try this:

Sum(TOTAL <Dim1, Dim3> Value)

Sum(TOTAL <Dim1, Dim3> Aggr(Value, Dim1, Dim2, Dim3))

Re: Sum AGGR divided by

Anonymous — Sun, 02 Apr 2017 12:52:27 GMT

Can you close the thread if you got your answer so that we need not open this thread to answer.

Re: Sum AGGR divided by

rospigliosi — Mon, 03 Apr 2017 15:19:38 GMT

Thank You Robin, I solved the problem with the NODISINCT