topic Re: Pivot Table Partial Sums not displaying in QlikView

Pivot Table Partial Sums not displaying

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

Hi All,

I have the below issue, i know the field Total is in,my intention is to exclude this on load, however the problem remains. My partial sums calculation does not work, I have changed the format of my QTY fields to NUM, but did not seem to resolve the issue.

Please assist, what am I missing here?

The partial sums is set up on Description, as i want the totals pertaining to all the descriptions together?

Thanks in Advance !

Re: Pivot Table Partial Sums not displaying

sunny_talwar — Thu, 06 Apr 2017 09:25:57 GMT

Are you using the field names without any aggregation here? Like QTY is a field which is being used here without the Sum() function? If that is true, then try this Sum(QTY)

Re: Pivot Table Partial Sums not displaying

Anonymous — Thu, 06 Apr 2017 09:30:26 GMT

Hi Ruan,

It is normal because the pivot table evaluate your partial sum like this : total of QTY for all description by FILE.

Try to use "Sum of rows" ; may be it will be your solution.

Go to the expressions tab and check sum of rows.

Re: Pivot Table Partial Sums not displaying

Anonymous — Thu, 06 Apr 2017 09:36:32 GMT

This seems to work , however, the total displayed is incorrect.

Re: Pivot Table Partial Sums not displaying

Anonymous — Thu, 06 Apr 2017 09:37:25 GMT

Hi,

The option to sum by rows is grayed out. however the above solution by Sunny is working, just needs tweaking.

Regards,

Re: Pivot Table Partial Sums not displaying

sunny_talwar — Thu, 06 Apr 2017 09:38:07 GMT

What is it displaying? What do you expect it to display?

Re: Pivot Table Partial Sums not displaying

Anonymous — Thu, 06 Apr 2017 09:41:05 GMT

Sorry, I was just looking at the wrong total, thought the total was at the bottom not top. Thanks for your help !

Much appreciated.

Re: Pivot Table Partial Sums not displaying

sunny_talwar — Thu, 06 Apr 2017 09:43:09 GMT

No problem.. you can move the placement of total on the presentation tab.... If you got what you wanted, please close this thread by marking correct and helpful responses.

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny