Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

richard_chilvers
Valued Contributor

Pivot table grand total


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

7 Replies

Re: Pivot table grand total

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

anbu1984
Honored Contributor III

Re: Pivot table grand total

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

richard_chilvers
Valued Contributor

Re: Pivot table grand total

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

ashwanin
Valued Contributor

Re: Pivot table grand total

For changing this

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

Re: Pivot table grand total

Can you post sample to look over.

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

Regards

ASHFAQ

richard_chilvers
Valued Contributor

Re: Pivot table grand total

Sorry - this made no difference.

anbu1984
Honored Contributor III

Re: Pivot table grand total

Can you post sample app