Qlik Community

Ask a Question

Suggest an Idea

Vote for your favorite Qlik product ideas and add your own suggestions.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources. Prep for the big move: READ DETAILS

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

Sonja_Bauernfeind
Digital Support
Digital Support

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

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. 

2020-08-21 14_36_40-Qlik Sense Pivot table_ _Expand_collapse ALL_ on single level - Console.png

 

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

Don't forget to Like posts and use the "Accept as Solution" button on content that answered your question! Thanks 🙂
17 Comments
pablolabbe
Luminary Alumni
Luminary Alumni

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

pritamdeb
Partner
Partner

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.

jlp
Employee
Employee
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.
Joseph
Contributor
Contributor

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.

Pivot Selction Example.gif

Patric_Nordstrom
Employee
Employee

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

Status changed to: Open - Collecting Feedback
elvidiocalderar
Partner
Partner

Many customers ask us this functionality

davidhillier
Contributor
Contributor

Should be a no-brainer ... 

marcel_olmo
Partner
Partner

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

elvidiocalderar
Partner
Partner
Thank you for this solution.
It's a good idea.
neverbuyit
Contributor
Contributor

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.