Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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!