Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

not collapsed calculated dimensions

Hi,


I have a pivot table with expanding columns and one calculated dimension (PY Price). The user needs to visualize the calculated

dimension for all levels even if he collapses one of the level. My problem is, when I collapse one column, the calculated

dimension - which is the last column in the table - disappears because it behaves as a dimension in a pivot table.
(see the enclosed file).
What should I do in order to always visualize the calculated dimension? Consider that I can't transform it into an

expression because on horizontal I have the detail for Month and it would split it into months

Thanks

Cristina

Community Browser