Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
MVP
MVP

Sum( Aggr( YourFirstExpression * YourSecondExpression, ClientGroup))

View solution in original post

5 Replies
Highlighted
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)

)

Highlighted
Contributor III
Contributor III

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

Highlighted
Contributor III
Contributor III

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

Highlighted
MVP
MVP

Sum( Aggr( YourFirstExpression * YourSecondExpression, ClientGroup))

View solution in original post

Highlighted
Contributor III
Contributor III

Many thanks.