Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
MalcolmCICWF
Contributor II

Conditional Show Dimension GetSelectedCount (1 selection)

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.

1 Solution

Accepted Solutions

Re: Conditional Show Dimension GetSelectedCount (1 selection)

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

2 Replies

Re: Conditional Show Dimension GetSelectedCount (1 selection)

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
Contributor II

Re: Conditional Show Dimension GetSelectedCount (1 selection)

wow I was making things too complicated, thanks