topic Re: Qty getting doubled while calculating sum in QlikView

Qty getting doubled while calculating sum

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

Dear All,

I'm calculating sum of qty sold as one exp and sum of qty sold multiplied by packsize in another exp.

But the first exp works fine but second one is not showing the correct values.

I tried to use the distinct in the second exp but still facing issues.

Regards,

Viresh

Re: Qty getting doubled while calculating sum

shiveshsingh — Sun, 05 May 2019 10:15:30 GMT

If you remove item code dimension, then what is the result?

Re: Qty getting doubled while calculating sum

rubenmarin — Sun, 05 May 2019 10:20:40 GMT

Hi, as Packsize is a dimension and will have only one value you can try with "Packsize*Sum(SalesQty)" or "Packsize*Column(1)"

Re: Qty getting doubled while calculating sum

vireshkolagimat — Sun, 05 May 2019 10:51:54 GMT

Hi, i think it works fine but can't show the total even though I've enabled show partial sum option in the presentation tab.

Thank you.

Re: Qty getting doubled while calculating sum

vireshkolagimat — Sun, 05 May 2019 10:52:38 GMT

Hi, i tried but no changes. Thank you.

Re: Qty getting doubled while calculating sum

rubenmarin — Sun, 12 May 2019 08:18:59 GMT

Hi, total fails because of having difrferent values for Packsize, you can set the expression as:
Sum(Aggr(Sum(SalesQty)*Packsize, ProductCode, ItemCode, Packsize))

Or just:
Sum(Aggr(Sum(SalesQty)*Packsize, Packsize)) //does the operation for each Packsize and sums all generated values

Re: Qty getting doubled while calculating sum

vireshkolagimat — Mon, 13 May 2019 07:27:27 GMT

Hi, I was able to fix it and used the same logic. Thank you.