Conditional Dimension - does it have limits?

[Anonymous]

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

[sunny_talwar]

Use the third argument to increase the number of selections showed

=GetFieldSelections(_Dimension, ',', 20)

UPDATE: Also, look here

GetFieldSelections ‒ QlikView

[Anonymous]

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

[sunny_talwar]

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

[Anonymous]

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

[sunny_talwar · Accepted solution]

Then try this

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

[Anonymous]

YOU ROCK!! THANKS!!!!