Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Conditionally show/hide expression column based on the expanded or collapsed columns?

Is it possible to conditionally show/hide an expression column based on what dimension columns are expanded or collapsed?

2 Replies
agilos_mla
Contributor III

Re: Conditionally show/hide expression column based on the expanded or collapsed columns?

You should try the dimensionality() function. Read details in the QV help

Ex. Dimensionality() returns 2 if 2 dimensions are expanded in the pivot.

Grand Total has dimensionality() =0

Michael

MVP
MVP

Re: Conditionally show/hide expression column based on the expanded or collapsed columns?

You are talking about a pivot table?

I don't think so.

You can use a condition in your expression using Dimensionality() / SecondaryDimensionality() to execute different code per dimension level (when using partial sums).

Community Browser