Qlik Community

Ideas

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

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More

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

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 🙂
4 Comments
Luminary
Luminary

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

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.

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.
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