Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

mikehannig_
New Contributor III

Show and Hide Subtotal in Pivot Table

Currently I create 2 pivot table: 1 with show partial sum is checked, the other is not.

But I'm having problem when I tried to change column position in non subtotal table, the subtotal table won't automatically change the column position (Of course, since it's 2 different tables).

Below is the example. I tried to move QuarterYear into horizontal position.

Capture.PNG

But when I click subtotal, the QuarterYear is not moving.

Capture.PNG

Is there any way to make this 2 tables correspondent? or is there any other way to achieve this?

Btw, I tried to make duplicate dimension instead of 2 different tables to show/hide subtotal. but it still doesn't solve this problem

Thanks in advance

Tags (2)
4 Replies
prasoon92
New Contributor

Re: Show and Hide Subtotal in Pivot Table

Have you made this horizontal table using slice and dice??

mikehannig_
New Contributor III

Re: Show and Hide Subtotal in Pivot Table

no. never heard of it. is it like a drilldown? could you give me an example? thank you

prasoon92
New Contributor

Re: Show and Hide Subtotal in Pivot Table

Create quarter year as normal vertical column and then slice and dice.

Process:select the column and try to roll that column in the circular way . It will automatically get converted into horizontal column.

balabhaskarqlik
Honored Contributor

Re: Show and Hide Subtotal in Pivot Table

To move columns within the pivot chart, you need to tick the "Allow Pivoting" option on the Presentation tab, so try with this option also.