topic Re: Sumproduct Problem in QlikView

Sumproduct Problem

schumi1980 — Wed, 25 Nov 2020 16:16:04 GMT

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

sasiparupudi1 — Thu, 27 Sep 2018 08:53:28 GMT

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 — Thu, 27 Sep 2018 09:01:42 GMT

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 — Thu, 27 Sep 2018 09:33:26 GMT

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

swuehl — Thu, 27 Sep 2018 09:41:07 GMT

Sum( Aggr( YourFirstExpression * YourSecondExpression, ClientGroup))

schumi1980 — Thu, 27 Sep 2018 10:34:29 GMT

Many thanks.