Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Hide expression column using Dimensionality

Is there any way in Pivot table to hide an expression column based on Dimensionality()? For example, in Conditional section of an expression can we put something like Dimensionality()=1 (i.e. when all the dimensions are collapsed)

I tried but it is not working. Is there any alternative for it?

3 Replies
Clever_Anjos
Employee
Employee

You can´t use this function

Dimensionality() is evaluated "per row" and conditional are evaluated only once "per graph"

Anonymous
Not applicable
Author

If you create an expression of just Dimensionality() then you can see the values it returns as per dimensions etc....

Not applicable
Author

Yes Bill. I already created it and it showed values based on collapse/expansion of dimensions. I was wondering if I could make an expression column visible using this function. But I guess I won't be able to do that using dimensionality. I need to find another workaround. Thanks!