topic Re: Conditional Dimension - does it have limits? in QlikView

Conditional Dimension - does it have limits?

Anonymous — Fri, 07 Jul 2017 16:48:20 GMT

Hello Everybody,

I have an app where I have a Pivot Table that shows 1 dimension by default and 10 more should be able to get activated by using the conditional dimension feature of QV 11.

It works fine when selecting the first extra 5 dimension. However, when I select a 7th dimension to be shown the current selection switches to NOT and shows the not selected ones.

Also, when I select all dimensions at the same time only the default dimension is being shown.

Does anybody know if there are limitations on how many columns can be selected as conditional dimension?

Cheers

Susanne

Re: Conditional Dimension - does it have limits?

sunny_talwar — Fri, 07 Jul 2017 16:55:18 GMT

Use the third argument to increase the number of selections showed

=GetFieldSelections(_Dimension, ',', 20)

UPDATE: Also, look here

GetFieldSelections ‒ QlikView

Re: Conditional Dimension - does it have limits?

Anonymous — Fri, 07 Jul 2017 17:24:23 GMT

Hmm..

when I use it with the way you describe then now all columns are visible as soon as I select only 1 dimension. My conditional formula is:

GetSelectedCount(Label1)>0 and GetFieldSelections(Label1,',',Type',20)>=1

Re: Conditional Dimension - does it have limits?

sunny_talwar — Fri, 07 Jul 2017 17:26:21 GMT

What was your expression previously (before making any changes I suggested)?

Re: Conditional Dimension - does it have limits?

Anonymous — Fri, 07 Jul 2017 17:27:24 GMT

GetSelectedCount(Label1)>0 and SubStringCount((GetFieldSelections(Label1),Type')>=1

Re: Conditional Dimension - does it have limits?

sunny_talwar — Fri, 07 Jul 2017 17:37:55 GMT

Then try this

GetSelectedCount(Label1) > 0 and SubStringCount(GetFieldSelections(Label1, ', ', 20),'Type') >= 1

Re: Conditional Dimension - does it have limits?

Anonymous — Fri, 07 Jul 2017 17:42:23 GMT

YOU ROCK!! THANKS!!!!