idea From now on, please track this idea from the Ideation por... in Suggest an Idea

Qlik Sense Pivot table: "Expand/collapse ALL" on single level

Sonja_Bauernfeind — Wed, 25 Nov 2020 08:53:26 GMT

When using a Pivot table with several levels, one can "right-click" on the level and use the option "expand/collapse All". This option does not allow to expand the single level.

Customers want to be able to expand a level "expand next level" and keep others collapsed.

This Idea was recorded as a copy of an old idea in the previous ideation system. It was again requested by a customer.

Re: Qlik Sense Pivot table: "Expand/collapse ALL" on single level

pablolabbe — Sun, 23 Aug 2020 19:12:57 GMT

Yes, we just need the same feature that already exists in Qlikview 😃

Re: Qlik Sense Pivot table: "Expand/collapse ALL" on single level

pritamdeb — Fri, 28 Aug 2020 04:30:20 GMT

Yes please. Other than being too far down the feature backlog, is there a genuine reason why this feature is still missing? I'd love to know if there is a non extension based workaround other than using conditional show/hide dimensions using variables.

Re: Qlik Sense Pivot table: "Expand/collapse ALL" on single level

johan_ennerup — Thu, 17 Sep 2020 07:08:35 GMT

This was actually one of the most annoying things for the business in a big QlikView to Qlik Sense migration when we got features from the business afterwards. It also has a performance impact when everyting is expanded at once - much better to allow it by level instead.

Re: Qlik Sense Pivot table: "Expand/collapse ALL" on single level

Joseph — Tue, 13 Oct 2020 19:25:42 GMT

I have workaround solution. Basically, (1) creating a list with the name of the pivot levels; (2) creating the list with a multiple select checkboxes; (3) displaying / including the levels when selected; (4) then expand all to support partial pivot result. Here is an example function to control the display of the levels.

=If(WildMatch(GetFieldSelections(Hierarchy,'|'),'*Region*') > 0, 1, 0)

Example data:

Menu:
NoConcatenate
LOAD * INLINE [
Hierarchy
Region
Market
BU
];

Data:
NoConcatenate
LOAD * INLINE [
Region, Market, BU, Qty
R1, M1, B1, 10
R1, M2, B2, 10
R2, M1, B3, 10
R2, M2, B4, 10
R3, M1, B5, 10
R4, M2, B6, 10
];

The checkbox UI is the SimpleFieldSelect.

Re: Qlik Sense Pivot table: "Expand/collapse ALL" on single level - Status changed to: Open - Collecting Feedback

Patric_Nordstrom — Mon, 09 Nov 2020 15:40:01 GMT

Thank you for your feedback on ways to improve our product. While this is something we understand would be useful, it's not on the short-term roadmap. Please continue to show your support for this idea.

Thanks,
Patric

Re: Qlik Sense Pivot table: "Expand/collapse ALL" on single level

elvidiocalderar — Wed, 25 Nov 2020 16:21:02 GMT

Many customers ask us this functionality

Re: Qlik Sense Pivot table: "Expand/collapse ALL" on single level

davidhillier — Tue, 20 Apr 2021 12:52:47 GMT

Should be a no-brainer ...

Re: Qlik Sense Pivot table: "Expand/collapse ALL" on single level

marcel_olmo — Tue, 20 Apr 2021 17:30:42 GMT

Totally agree, I think it's not quite difficult to do and very useful

Re: Qlik Sense Pivot table: "Expand/collapse ALL" on single level

elvidiocalderar — Wed, 21 Apr 2021 06:26:20 GMT

Thank you for this solution.
It's a good idea.

Re: Qlik Sense Pivot table: "Expand/collapse ALL" on single level

neverbuyit — Mon, 10 May 2021 15:28:24 GMT

Putting in my vote to please include this feature as quickly as possible. This expand/collapse all feature was a great addition, however it is a great source of frustration for our business units who have to click individually through each dimension to get to the desired level of drill down rather than all at once, which a previous poster noted has performance implications.

As such, per one of our end users the feature, "unfortunately comes off as as a half-baked implementation". If this can be bubbled up the list to make it into a release in the next couple of months that would be great and would go a long way to ensuring that we can have Qlik Sense be the main source of analytics engagement in our organization.

Re: Qlik Sense Pivot table: "Expand/collapse ALL" on single level

sttspyrid — Mon, 17 May 2021 13:34:35 GMT

Hi all,

Actually, some weaknesses of the product seem unbelievable. It is hard to believe that they cannot be covered in a reasonable portion of time. We are on 2021 and the absence of Pivot table: "Expand/collapse ALL" on single level or the absent Bold/Italic format on all objects etc. we are deeply concered us.

@Patric, please convey our concerns to those in charge in order to rexamine the short-term roadmap.

Best regards,

Thomas

Re: Qlik Sense Pivot table: "Expand/collapse ALL" on single level

Commander — Mon, 31 May 2021 09:05:49 GMT

Request from a customer. I was surprised it is not possible

Re: Qlik Sense Pivot table: "Expand/collapse ALL" on single level

sttspyrid — Mon, 31 May 2021 10:04:35 GMT

Hi All,

I check it again and everything works fine. Possible problem with my version.

Best regards,

Thomas

Re: Qlik Sense Pivot table: "Expand/collapse ALL" on single level

stephenfr — Wed, 02 Jun 2021 16:38:15 GMT

I agree, this is a must have. Without it, I would often not use the pivot table, because it would not be suitable to do the data analysis. Too many clicks are needed to expand to the next level.

Re: Qlik Sense Pivot table: "Expand/collapse ALL" on single level

Tamarah — Thu, 05 Aug 2021 13:08:29 GMT

Hi @sttspyrid ,

In your last comment you say that after checking again everything works fine... what is the Qlik Sense version you are working with as we speak? I have Feb2021 installed where the requested feature is not available.

Thank you in advance for your reaction.

Kind regards, Tamarah

Re: Qlik Sense Pivot table: "Expand/collapse ALL" on single level

Almen — Wed, 01 Sep 2021 08:28:49 GMT

I feel like the Qlik Sense Team has overlooked quite a few features from QlikView, but those have a huge impact for many people in daily business.

So yeah, it's been a year and no news if this will ever be implemented, really disappointing.

Re: Qlik Sense Pivot table: "Expand/collapse ALL" on single level

sttspyrid — Wed, 01 Sep 2021 09:32:05 GMT

Hi Tamarah,

Correct. On single level is not working!

Is working for all levels.

Our Qlik Sense users, needs the ability to expand/collapse on single level which is not supported yet.

Sorry, for my misunderstanding.

Best regards,

Thomas

Re: Qlik Sense Pivot table: "Expand/collapse ALL" on single level

Olivier_W — Wed, 13 Oct 2021 08:28:34 GMT

good idea.

Re: Qlik Sense Pivot table: "Expand/collapse ALL" on single level

Shisho_Karsenty — Tue, 19 Oct 2021 10:21:50 GMT

Customer requirement...