Discussion board where members can get started with QlikView.
I have a small calculation problem which drives me crazy:
All results in the table are from a large number of clients which are put into different buckets.
The second yellow column was calculated using [Measure 1] / aggr(formula for measure 2,Client Group).
However, I do not manage to get the blue field calculated. In excel I would use sumproduct using both yellow columns.
How can I do that in Qlikview?
Sum( Aggr( YourFirstExpression * YourSecondExpression, ClientGroup))
View solution in original post
May be Try
Sum(Aggr([Measure 1] / aggr(formula for measure 2,Client Group),Client Group))).,
[Measure 1] / aggr(formula for measure 2,Client Group)
If I do it like that I only get the sum of the yellow elements in result 1.
However, I should have the portfolio value using the values aggr(formula for measure 2,Client Group).
Every question on the board regarding this sum product is left unanswered. Does that mean it is impossible to calculate it?