Enable Conditional Dimensionality Pivot table

[#1]

Hello

In a pivot table I want to show or to hide a column depending on the dimensionality. My condition is if(Dimensionality()=2,1,0)
. But it doesn't work as I expect. I want the column ShowOrNoShow is showed when the dimensionality = 2

Thanks in advance

[jagan · Accepted solution]

Hi,

Dimensionality won't work in Conditional option, it works only in expression.

Regards,

Jagan.

[#3]

Hi.

Many thanks for the prompt reply.

Any alternative solution for achieving the same thing?

Regards

[jagan]

Hi,

I think it is not possible.

Regards,

jagan.

[#5]

Ok. Thank you very much.

I have read this another message and I understand the point of view.

Does anyone have an idea of why Dimensionality() does not work with the Expression Conditional?

What I want is to show the column if some node of level 2 is expanded. I can not do it with dimensionality

Perhaps in another thread.

Clara

[Anonymous]

I've made fields white-on-white to hide them at certain levels.

[stefano6310]

I understand what is written in http://community.qlik.com/message/400484#400484 but ...

If I use Max () inside the if
if(Max(Dimensionality())=2,1,0)

I always have on the all rows the same value which is the deeper level of my table.

But also in this case the Conditional option does not work. I think this is a limit of Qlik