Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
schumi1980
New 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

Tags (1)
1 Solution

Accepted Solutions
MVP
MVP

Re: Sumproduct Problem

Sum( Aggr( YourFirstExpression * YourSecondExpression, ClientGroup))

View solution in original post

5 Replies
sasiparupudi1
Honored Contributor III

Re: Sumproduct Problem

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
New Contributor III

Re: Sumproduct Problem

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
New Contributor III

Re: Sumproduct Problem

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

MVP
MVP

Re: Sumproduct Problem

Sum( Aggr( YourFirstExpression * YourSecondExpression, ClientGroup))

View solution in original post

schumi1980
New Contributor III

Re: Sumproduct Problem

Many thanks.