Vote for your favorite Qlik product ideas and add your own suggestions.
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.
Yes, we just need the same feature that already exists in Qlikview 😃
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.
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)
Menu:NoConcatenateLOAD * INLINE [HierarchyRegionMarketBU];
Data:NoConcatenateLOAD * INLINE [Region, Market, BU, QtyR1, M1, B1, 10R1, M2, B2, 10R2, M1, B3, 10R2, M2, B4, 10R3, M1, B5, 10R4, M2, B6, 10];
The checkbox UI is the SimpleFieldSelect.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.