topic Set analysis help in QlikView

Set analysis help

ngreddy1982 — Thu, 25 Nov 2021 14:29:46 GMT

Hi All,

I am trying to calculate product cost which comes from the Revenue * Product Factor, it is not working as expected. Please see the attachment. Please tell me what am I doing wrong here ? is this even the correct approach.

Re: Set analysis help

Vegar — Thu, 25 Nov 2021 14:51:47 GMT

It looks like you have a one factor per row of revenue. I think it should be enough to just do

Sum(Revenue*Product_Factor)

Re: Set analysis help

ngreddy1982 — Thu, 25 Nov 2021 15:32:08 GMT

Hi Vegar,

I have 2 different events Revenue and Cost, so Revenue is coming from Revenue Event and Product_Factor is coming from Cost and also I have to use Month Relative range in the expression.

Re: Set analysis help

ngreddy1982 — Thu, 25 Nov 2021 15:31:56 GMT

Thank you, I got this working, with AGGR I need to add all the dimensions I have in the chart. With Centre, I have added the Month name as well. it is working fine.

Thank you Vegar.