topic Partial Sum in PivotTable in QlikView

Partial Sum in PivotTable

Anonymous — Thu, 25 Feb 2016 14:20:37 GMT

Hello,

I have a problem on the partial sum of my size in my PivotTable, because I do not understand why we are not done on all lines.

As shown in the pictures attached:

Thank you in advance for your help.

Wishing you a good day,

Cocalero.

Re: Partial Sum in PivotTable

marcus_sommer — Thu, 25 Feb 2016 16:29:57 GMT

It will be depend on the kind of your expression if you get a partial sum. An expression like sum(AnyField) will nearly always work but something like quantity * price won't - for such kind of expression you need a wrapping with aggr, something like this: sum(aggr(quantity * price, YourDimensions)).

- Marcus

Re: Partial Sum in PivotTable

Anonymous — Thu, 25 Feb 2016 16:35:54 GMT

Thanks for your return Marcus Sommer,

But I do not understand why the partial sum does not work 😕 (This is the first column of the photo attached to my first post), it works only for the third line.

Re: Partial Sum in PivotTable

marcus_sommer — Thu, 25 Feb 2016 16:45:40 GMT

Please provide a screenshot where the dimensions are visible and also how the expressions look like.

- Marcus

Re: Partial Sum in PivotTable

Anonymous — Fri, 26 Feb 2016 08:55:17 GMT

Hello,

Here attached the pictures requested:

However, the sum does not have expressions but I just activate the partial sum in the options.

Thank you again for your help !

Re: Partial Sum in PivotTable

marcus_sommer — Fri, 26 Feb 2016 10:59:49 GMT

But you must have an expressions within the tab expressions - how looked they?

- Marcus