Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
kizzydavies
Not applicable

Moving Total Rows on Pivot Charts

Hello, 

I have Qlik Sense desktop.  When I create a pivot and turn on totals they always show on the first line of the table instead of at the bottom.  How can i move the totals?

Thanks

3 Replies
abhishek_singla
Not applicable

Re: Moving Total Rows on Pivot Charts

Hi Kizzy,

No, this is not possible in qlik sense. There is a reason why total is shown on top instead of bottom.

Think of it this way:

If you have millions of records and total is showing on the bottom it will become cumbersome to just scroll down to see total. That's why we show total on the above.

And on a first glance, total on above look better.

Hope this help.

Regards,

Abhishek

OmarBenSalem
Not applicable

Re: Moving Total Rows on Pivot Charts

It's only possible in straight table

kizzydavies
Not applicable

Re: Moving Total Rows on Pivot Charts

Hi Abhishek and Omar,

Thanks very much for your quick feedback.

I cannot use a straight table as this does not allow me to add multiple columns.

Is there any way to suggest this as an enhancement as not all users are dealing with 1000's of lines of data so it would be good to have the option of where to place the totals.

Thanks,

Kizzy