topic Re: partial sum is showing wrong in QlikView

partial sum is showing wrong

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

Hi All,

I have five dimensions and one expression to calculate the sum of amount from a table.

When I select all the values from one dimension and check the partial sum checkbox, the subtotal on top is showing wrong amount. But when I export the same data to excel and calculate the sum, it will be different from Qlikview.

Thanks.

Re: partial sum is showing wrong

jyothish8807 — Wed, 21 Nov 2018 10:49:14 GMT

Hi,

Try to check 'sum' of rows option.

Else you have to try with Aggr function.

Re: partial sum is showing wrong

Colin-Albert — Wed, 21 Nov 2018 17:46:40 GMT

In a pivot table you do not have the option to select whether the sum is calculated using the "expression total" or "sum of rows" as you do on a straight table. In a pivot table, the expression total is always used.

To get a sum of rows in a pivot table you must use the aggr() function with the pivot dimensions included in the expression.

Sum(AGGR(SUM(YourExpression),Dimesion1, Dimension2,....DimensionN))

Re: partial sum is showing wrong

manjunaths — Thu, 22 Nov 2018 05:47:09 GMT

hi colin,
Thanks for your reply.
I have used "Sum(AGGR(SUM(YourExpression),Dimesion1, Dimension2,....DimensionN))".
But still it is not working as expected. When I select individual field then amount is showing correctly. But when I select all the values in the field then it not showing amount against any of them.