Unable to collapse pivot table column when dimension is using an expression/formula
Article Number: 000062439 | Last Modified: 2019/03/01
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 SR17. This behavior in 12.30 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.
QV-16336 and QLIK-84622 bugs indicate that this was an intentional behavior change in 12.x version.
A feature request has been logged to request that this behavior be improved in future versions.
Qlik has previously received feedback on this feature and recorded the request for future review. For up to date information, please contact support at support.qlik.com referencing this article.
This was reported to R&D via bugs QV-16336 and QLIK-84622. The bug regarding the collapse behavior was closed as working as designed.
change the order and arrangement of the columns so that the dimension with the expression is not the last one in the collapsible group. This will mitigate the empty columns being shown.
Per R&D: There was 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.