topic Double aggregation in QlikView

Double aggregation

Wed, 13 Jan 2010 19:45:35 GMT

Hi,

I can't solve this problem.I have a table with 3 dimensions (A, B, C) and one numeric value (H)

I want to create a chart with

One Dimension : A
One Expression :

The sum of H, calculated only for one value of B corresponding of the maximum of H for each C including in B

To calculate the Max for each B, i tried Max( Aggr( Sum(H) , B , C) ) => OK

But sum( Max( Aggr( Sum(H) , B , C) ) ) is not correct. I don't understand why ?

Maybe some help is welcome.

Regards

Jean-Jacques

Double aggregation

johnw — Wed, 13 Jan 2010 20:58:04 GMT

Sorry, but I can't figure out what you want. Here's some sample data. What do you want the chart to display?

A B C H
1 1 1 1
1 1 2 2
1 2 1 4
1 2 2 8
2 1 1 16
2 1 2 32
2 2 1 64
2 2 2 128

Double aggregation

Wed, 13 Jan 2010 21:31:32 GMT

Hi John, thanks for your help

I want to display a chart with

A Expression

1 10 ( 2 + 😎

2 160 (32 + 128)

Hope to answer you

Double aggregation

johnw — Wed, 13 Jan 2010 22:09:13 GMT

Well, I can get the right numbers for that data set with sum(aggr(max(H),A,B)), but I suspect that isn't what you want, since I still don't understand what you're trying to do. If that doesn't work for your real data, can you give me a better example data set?

Double aggregation

Wed, 13 Jan 2010 22:17:39 GMT

Thank you John, i made a mistake in the expression, your expression is working well.