Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
rospigliosi
Contributor

Sum AGGR divided by

Hi experts,

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

Dim 1Dim 2Dim 3Dim3 Value
TOTAL: 140
ABE0
ABF0
ABG0
ACE0
ACF0
ACG0
ADE84
ADF15
ADG41

But I would like to obtain this:

Dim 1Dim 2Dim 3Dim3 Value
Total: 140
ABE84
ABF15
ABG41
ACE84
ACF15
ACG41
ADE84
ADF15
ADG41

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.

1 Solution

Accepted Solutions
roharoha
Valued Contributor III

Re: Sum AGGR divided by

perhaps:

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

or

sum(total <Dim1,Dim3> value)

6 Replies
laddu_927
Valued Contributor

Re: Sum AGGR divided by

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

vishsaggi
Esteemed Contributor III

Re: Sum AGGR divided by

Try this? Else can you share a sample ?

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

roharoha
Valued Contributor III

Re: Sum AGGR divided by

perhaps:

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

or

sum(total <Dim1,Dim3> value)

Re: Sum AGGR divided by

May be try this:

Sum(TOTAL <Dim1, Dim3> Value)

or

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

laddu_927
Valued Contributor

Re: Sum AGGR divided by

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

rospigliosi
Contributor

Re: Sum AGGR divided by

Thank You Robin, I solved the problem with the NODISINCT

Community Browser