topic Maximum Sum of Dimensions - Aggregation in QlikView

Maximum Sum of Dimensions - Aggregation

lorenwood — Thu, 09 Jan 2014 18:13:31 GMT

Hello all, wanted to know if anyone can help with this issue: I have a table see below:

What I need to calculate is based on the highest sum of the volume , show only associated dimensions with the highest sum of volume at that level:

So for Payer A , the result should be Volume =800 and Restrictions = 'N' and Type = 'Actual'

For Payer B, the result should be Volume = 700 and Restrictions = 'Y' and Type ='Preferred' so the end result should look something like this:

Is there any way to accomplish this in an expression in a straight table?

Any help would appreciated !

Thanks

Loren

whiteline — Thu, 09 Jan 2014 18:41:32 GMT

Hi.

If you need the expression you can start from that one:

=if(Sum (Volume)>Sum (total<Payer>Volume)/2, Sum (Volume))

It works for the sample provided, but I guess you real data are more complex.

Also consider calculating the flag that the row is relative to the highest sum of the volume in script.

Gysbert_Wassenaar — Thu, 09 Jan 2014 18:44:37 GMT

See attached qvw