topic Re: Enable Conditional Dimensionality Pivot table in QlikView

Enable Conditional Dimensionality Pivot table

Fri, 24 Oct 2014 06:54:39 GMT

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

Re: Enable Conditional Dimensionality Pivot table

jagan — Fri, 24 Oct 2014 07:06:51 GMT

Hi,

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

Regards,

Jagan.

Re: Enable Conditional Dimensionality Pivot table

Fri, 24 Oct 2014 07:16:26 GMT

Hi.

Many thanks for the prompt reply.

Any alternative solution for achieving the same thing?

Regards

Re: Enable Conditional Dimensionality Pivot table

jagan — Fri, 24 Oct 2014 07:28:12 GMT

Hi,

I think it is not possible.

Regards,

jagan.

Re: Re: Enable Conditional Dimensionality Pivot table

Fri, 24 Oct 2014 08:55:00 GMT

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

Re: Enable Conditional Dimensionality Pivot table

Anonymous — Fri, 06 Mar 2015 20:45:27 GMT

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

Re: Enable Conditional Dimensionality Pivot table

stefano6310 — Tue, 24 Mar 2015 16:58:56 GMT

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