Hide rows in pivot table on calculated dimension without losing the subtotal

Raymzzz — Sat, 16 Nov 2024 19:47:47 GMT

Dear all,

I would like to hide certain rows in my pivot table for one specific value of a calculated dimension, which looks like this :

=if(Aggr(Count({$<[Record Type]={'DEAL'}>}DISTINCT DealType), YEARCIF)>=3, '>=3', '<3')

I would like to hide the rows for '<3', but when I do so, the subtotal in the expression where I want to calculate the percentage on that subtotal, changes too, and that's something I want to avoid, since I want to keep the percentage on the original subtotal.

Lines I want to Keep (in yellow)

Hopefully the pictures in attachment, can clearify what I exactly mean. The lines in yellow are the the lines I want to keep (i.e. where my calculated dimension equals '>=3'). The other picture shows my current result. As you can, the calculated percentage does change to 100%, which is not what I want. I want to keep the initial percentage.

Thank you very much in advance for your responses.

Stijn, Belgium

Current Result

Re: Hide rows in pivot table on calculated dimension without losing the subtotal

Brett_Bleess — Tue, 05 Nov 2019 20:45:41 GMT

Stijn, I am no guru on Set Analysis, leaving you a link to a 40 minute recording from one of our gurus on the QIX Engine, that I hope may fill in some gaps for you as to the why of things such that you will realize what is wrong, as I am not going to be much help to you on this one. This will kick things back up as well, so someone else may chime in as well with something for you that is more helpful, but I will include a Design Blog link too, might be of some use here.

https://www.youtube.com/watch?v=wevhFK_AID8&feature=youtu.be

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344

Apologies I am not more help.

Regards,
Brett

topic Re: Hide rows in pivot table on calculated dimension without losing the subtotal in QlikView

Hide rows in pivot table on calculated dimension without losing the subtotal

Re: Hide rows in pivot table on calculated dimension without losing the subtotal