topic Re: Pivot table grand total in QlikView

Pivot table grand total

richard_chilvers — Tue, 02 Dec 2014 09:33:45 GMT

I have a chart which displays as a straight table with a grand total as the top row. If I change the chart to a pivot table, the grand total disappears. The total settings in QV can be quite confusing, but I have checked every setting I can, without success. I have even checked against the settings in a very similar pivot table, which works fine. Sub-totals seem to work fine. Any advice from anyone to get the grand total back?

Thanks

Re: Pivot table grand total

ashfaq_haseeb — Tue, 02 Dec 2014 09:36:55 GMT

Hi,

First convert this to pivot table.

Then Go to chart properties --> Presentation tab --> Select required dimension and click on show partial sum.

Let me know if that worked.

Regards

ASHFAQ

Re: Pivot table grand total

anbu1984 — Tue, 02 Dec 2014 09:37:39 GMT

If you set "Show Partial Sum" for the first dimension, then you will get Grand total in Pivot table

Re: Pivot table grand total

richard_chilvers — Tue, 02 Dec 2014 09:55:49 GMT

Thans Ashfaq and anbu, but the option for Partial Sums is greyed out for that dimension.

Re: Pivot table grand total

ashwanin — Tue, 02 Dec 2014 10:01:19 GMT

For changing this

go to Properties of chart-->Style-->Current style choose Classic

Re: Pivot table grand total

ashfaq_haseeb — Tue, 02 Dec 2014 10:02:00 GMT

Can you post sample to look over.

Try by dragging dimensions upward and downward in your Pivot chart itself.

Regards

ASHFAQ

Re: Pivot table grand total

richard_chilvers — Tue, 02 Dec 2014 10:05:46 GMT

Sorry - this made no difference.

Re: Pivot table grand total

anbu1984 — Tue, 02 Dec 2014 10:18:19 GMT

Can you post sample app