Announcements
cancel
Showing results for
Did you mean:
Contributor III

Sumproduct Problem

Dear All,

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?

Many thanks.

Best regards,

Jan

1 Solution

Accepted Solutions
MVP

Sum( Aggr( YourFirstExpression * YourSecondExpression, ClientGroup))

5 Replies
Master III

May be Try

If(RowNo()=0,

Sum(Aggr([Measure 1] / aggr(formula for measure 2,Client Group),Client Group))).,

[Measure 1] / aggr(formula for measure 2,Client Group)

)

Contributor III
Author

Hi Sasidhar

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).

Contributor III
Author

Every question on the board regarding this sum product is left unanswered. Does that mean it is impossible to calculate it?

MVP

Sum( Aggr( YourFirstExpression * YourSecondExpression, ClientGroup))

Contributor III
Author

Many thanks.

Community Browser