Conditional Show Dimension GetSelectedCount (1 selection)

[MalcolmCICWF]

Qlik Community,

I have a straight table with some expressions broken out by a bunch of dates as my dimension. I want a second dimension in my table, but I only want this dimension viewable when I select a single date... Otherwise I want PoolID hidden, how can I achieve this? I am trying combinations of the below...

=if(GetSelectedCount(Date)=1,PoolID)

It seems easy, but isn't working.

[sunny_talwar · Accepted solution]

May be try with just this as your dimension

PoolID

and then use condition on your dimension

GetSelectedCount(Date) = 1

or

Count(DISTINCT Date) = 1

[MalcolmCICWF]

wow I was making things too complicated, thanks