topic Re: Remove Subtotals from Pivot Table in QlikView

Remove Subtotals from Pivot Table

varunamin — Sat, 16 Nov 2024 00:32:14 GMT

Hi,

I want to hide the subtotals in Pivot Table. I want the partial sums and always fully expanded to be checked.

Want to get rid of highlighted row in red. Thanks!

Re: Remove Subtotals from Pivot Table

Saravanan_Desingh — Fri, 05 Jun 2020 02:36:25 GMT

It seems to Null or Null Sting('') row for Defects. Try selecting 'Suppress When Value Is Null'

Re: Remove Subtotals from Pivot Table

varunamin — Fri, 05 Jun 2020 02:39:39 GMT

Selecting 'Suppress When Value Is Null' changes the percentage calculations.

Re: Remove Subtotals from Pivot Table

Saravanan_Desingh — Fri, 05 Jun 2020 02:41:39 GMT

In that case, use AGGR in your Expression to bring all possible values of Defects.

Re: Remove Subtotals from Pivot Table

nevilledhamsiri — Fri, 05 Jun 2020 05:57:26 GMT

Hi! Simply what could you do is to press Ctl+G after curser being kept right on to the required row to be excluded & assign the colour may be white so that the row will no longer be visible.

Neville

Re: Remove Subtotals from Pivot Table

varunamin — Fri, 05 Jun 2020 19:09:19 GMT

How should I use Aggr? I have 2 formulas 1) Using Count(Distinct(A))

2) (Count(DISTINCT(A))/Count(DISTINCT total <>())

Thnaks!

Re: Remove Subtotals from Pivot Table

varunamin — Fri, 05 Jun 2020 19:11:53 GMT

Doing that makes all the field color to white.

Re: Remove Subtotals from Pivot Table

Saravanan_Desingh — Fri, 05 Jun 2020 19:31:35 GMT

Can you try like this?

Count(Distinct(A)) Count(Aggr(A,Defects,J_Priority_Mod,[J_Onboard vs Offboard],Status))

(Count(DISTINCT(A))/Count(DISTINCT total <>()) (Count(Aggr(A,Defects,J_Priority_Mod,[J_Onboard vs Offboard],Status)) / Count(total <> Aggr(A,Defects,J_Priority_Mod,[J_Onboard vs Offboard],Status))

Re: Remove Subtotals from Pivot Table

Brett_Bleess — Wed, 01 Jul 2020 12:29:16 GMT

Did Saran's last post get you a working solution? If so, we would greatly appreciate your returning to this thread and closing things out by using the Accept as Solution button on that post to mark it as the solution, which will give them credit for the assistance and it lets other Community Members know it worked too. If you require further assistance, please leave an update post, and if you did something different, please consider posting what you did and then mark that post using the button.

Regards,
Brett