topic Incorrect Partial Sum on Pivot Table in QlikView

Incorrect Partial Sum on Pivot Table

Wed, 25 Nov 2020 16:16:04 GMT

Partial sum are incorrectly displayed on the pivot table. Can anyone spot the mistake I've made?

Here are two expressions that I have the problem:

SUM({$<Έτος={$(=Max(Έτος))}>}[Πίστωση Γραμμής Λογιστικού Άρθρου])

SUM({[Group 1]<Έτος=$::Έτος,Τρίμηνο=$::Τρίμηνο,Μήνας=$::Μήνας>}[Πίστωση Γραμμής Λογιστικού Άρθρου])

Re: Incorrect Partial Sum on Pivot Table

rubenmarin — Sat, 07 Oct 2017 17:32:07 GMT

Hi Thodoris, can you post a sample or at least an image that shows the issue?

Re: Incorrect Partial Sum on Pivot Table

Sat, 07 Oct 2017 18:05:54 GMT

The correct sum is 499,75

Re: Incorrect Partial Sum on Pivot Table

pradosh_thakur — Sat, 07 Oct 2017 20:18:49 GMT

It seems you missed a double Quotes

SUM({$<Έτος={"$(=Max(Έτος))"}>}[Πίστωση Γραμμής Λογιστικού Άρθρου])

Please share a screenshot or a sample qvw which will help us help you fast and better.

regards

Pradosh

Re: Incorrect Partial Sum on Pivot Table

rubenmarin — Mon, 09 Oct 2017 17:01:05 GMT

Hi Thodoris, this behaviour can be caused if one amount record is painted in two different dimension values.

Just a guess but seems that the rows with ID_KINH... "0FFA6D8..." and "CDADF4..." (both with an amount of 4,03) are really the same record.

Can you confirm this?

Re: Incorrect Partial Sum on Pivot Table

pradosh_thakur — Tue, 10 Oct 2017 05:25:49 GMT

Hi Thodoris

Are you changing the default format of 2017 column in the numbers tab by any chance? Sometimes i have noticed if you set them not to show decimal this kind of thing can happen.

If you are doing so can you please make the number format expression default to show decimal and we can be sure that it is not causing the issue.

regards

Pradosh

Re: Incorrect Partial Sum on Pivot Table

aivislau — Sat, 21 Apr 2018 12:43:37 GMT

I've had similar problem and found out that qw does not sum equal values (4,03 in your case) by "show partial sums" if there are other dimensions where those values cannot be distinguished between (empty cells or the same data for both values). Add the the data for any other dimension to differ those two values and your totals will be fine. At least I managed the situation that way.

Re: Incorrect Partial Sum on Pivot Table

manjunaths — Wed, 21 Nov 2018 07:25:09 GMT

Hi Aivislau,

Can you explain something more about this issue.