topic Re: SUMPRODUCT in QlikView

SUMPRODUCT

winniethepooh — Wed, 31 May 2023 08:16:59 GMT

Hello,

I'm trying to get sumproduct result as in excel file for %Sales & GM2 Target at supracategory level. In this case, for mobile phones 7.4%.

Can you please help me?

%Sales * GM2 Target doesn't work (result will be 8.9%).

Re: SUMPRODUCT

chrismarlow — Fri, 09 Jun 2023 11:38:20 GMT

Hi,

I can't open your QVW, but think you need to look at Total Mode, so from toy app below only difference between 3rd and 4th expression in screenshot from toy application below is on the 4th Total Mode is set to Sum of Rows - which gives same as SUMPRODUCT would in Excel.

Cheers,

Chris.

sales: Load * Inline [ Order, Product 1, X 2, X 3, X 4, Y 5, Y 6, Z 7, Z 8, Z 9, Z 10, Z ]; target: Load * Inline [ Product, Target X, 5% Y, 10% Z, 20% ];

Re: SUMPRODUCT

sidhiq91 — Fri, 09 Jun 2023 13:38:28 GMT

@winniethepooh Could you please provide some sample excel file and how are you calculating % Sales

Re: SUMPRODUCT

winniethepooh — Fri, 09 Jun 2023 13:51:52 GMT

It worked! Thank you 🙏