topic Re: Hide expression column using Dimensionality in QlikView

Hide expression column using Dimensionality

Wed, 25 Nov 2020 16:16:04 GMT

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?

Re: Hide expression column using Dimensionality

Clever_Anjos — Mon, 14 Mar 2016 18:34:37 GMT

You can´t use this function

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

Re: Hide expression column using Dimensionality

Anonymous — Mon, 14 Mar 2016 18:48:11 GMT

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

Re: Hide expression column using Dimensionality

Mon, 14 Mar 2016 18:56:15 GMT

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!