Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
schumi1980
Contributor III
Contributor III

Sumproduct Problem

Dear All,

I have a small calculation problem which drives me crazy:

sumproduct.jpg

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
swuehl
MVP
MVP

Sum( Aggr( YourFirstExpression * YourSecondExpression, ClientGroup))

View solution in original post

5 Replies
sasiparupudi1
Master III
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)

)

schumi1980
Contributor III
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).

schumi1980
Contributor III
Contributor III
Author

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

swuehl
MVP
MVP

Sum( Aggr( YourFirstExpression * YourSecondExpression, ClientGroup))

schumi1980
Contributor III
Contributor III
Author

Many thanks.