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.
3 people like this idea