Vizlib Home Try Vizlib

Pivot Table: Collapse to dimension / Expand to dimension

 In QlikView, pivot tables could be expanded to a specific dimension by right clicking that dimension and selecting "Expand all". Likewise, "Collapse all" could be used to collapse to a specific dimension. In Qlik Sense, this is unfortunately not an option - Expand All and Collapse All always operate on the entire table (so collapse is always to the first dimension and expand is always to the last dimension). Expand by hand, one cell at a time, is not a realistic option for larger pivot tables.

It would be very helpful if the QlikVIew functionality could be mimicked in Vizlib Pivot - allowing to easily expand or collapse to the desired level using a button or a right-click menu.

8 people like this idea
  • +1 this feature!  Would be really useful, and make the pivit much more user friendly!

  • +1 as well! Totally agree - I have several users requesting this. Would be great having this feature in the Vizlib Pivot table! 

  • +1 from me as well! That would be a very much appreciated feature

  • This is a mandatory feature to have a really usable pivot table. Please implement it, this is really  a problem currently in our dashboards to not have a way to expand or collapse a full visible dimension, by a simple right click action 

  • +1 here also

    must have feature not available in Qlik sense

  • Vizlib team : to implement or not ?

    please tell us what is your feeling...


  • Hi Patrice

    We have marked this as planned, which you can see at the top of the screen. This means that we aim to provide this, given that it is possible to implement without negatively impacting other features or products

  • Hi Piers, 

    any news on this fetaure request? Is this still planned and when yes, when will this be implemented? 

    This is a really crucial feature, where users asked for this very often. 

    Thanks in advance,



  •  I'd also love an update on this one. It's possibly our biggest obstacle in getting users on board with QV-to-QS conversion.

Login to post a comment