The expected behavior when the collapsing feature is used in a dimension column is that the dimensions columns to the right of it will get hidden/collapsed and that is working as it has been described in 11.20 SR 17.
This behavior in QlikView 12 versions (November 2018 and up) works as above only when the dimension is not using an expression. When the dimension includes any expression, the expand / collapse all behavior does not work the same way as it used to in 11.20.
Environment:
QlikView version November 2018 and up
Resolution:
This is working as designed, although a feature request has been recorded.
Workaround:
Change the order and arrangement of the columns so that the dimension with the expression is the last one in the collapsible group. This will mitigate the empty columns being shown. Qlik has previously received feedback on this feature and recorded the request for future review. For the QlikView specific Feature Request, see
Pivot table with dynamic Dimension: Collapse does not work as expected.For Qlik Sense, see
Expand/Collapse a pivot branch
More information/cause:
This is caused by an intentional change in behavior in 12.x track with calculated dimensions where cardinality is zero in order to safeguard that all cells are properly calculated, displayed / suppressed, collapsed / expanded etc. QLIK-84622 "GetHyperCubeStackData return all Dimensions even when Calc Dim result is null - if it is a Calculated Dimension and cardinal is zero, do not remove the dimension underneath." Please note that calculated dimensions are not just simple transformations of a single field but may contain multiple field references which means that all cases, simple or complex, will have to be managed with the same set of generic rules.