topic Re: Show and Hide Subtotal in Pivot Table in QlikView

Show and Hide Subtotal in Pivot Table

Anonymous — Sun, 15 Jul 2018 05:14:31 GMT

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.

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

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

Re: Show and Hide Subtotal in Pivot Table

prasoon92 — Sun, 15 Jul 2018 06:36:09 GMT

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

Re: Show and Hide Subtotal in Pivot Table

Anonymous — Sun, 15 Jul 2018 08:37:08 GMT

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

Re: Show and Hide Subtotal in Pivot Table

prasoon92 — Sun, 15 Jul 2018 09:14:32 GMT

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.

Re: Show and Hide Subtotal in Pivot Table

BalaBhaskar_Qlik — Mon, 16 Jul 2018 10:00:24 GMT

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.