topic Conditional Show Dimension GetSelectedCount (1 selection) in QlikView https://community.qlik.com/t5/QlikView/Conditional-Show-Dimension-GetSelectedCount-1-selection/m-p/1421017#M428717 <HTML><HEAD></HEAD><BODY><P>Qlik Community,</P><P></P><P>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...</P><P><SPAN style="font-size: 12pt;">=</SPAN><SPAN style="font-size: 12pt;"><SPAN style="color: #0000ff;">if</SPAN>(<SPAN style="color: #0000ff;">GetSelectedCount</SPAN>(<SPAN style="color: #800000;">Date</SPAN>)=1,<SPAN style="color: #800000;">PoolID</SPAN></SPAN><SPAN style="font-size: 12pt;">) </SPAN></P><P></P><P><SPAN style="font-size: 12pt;">It seems easy, but isn't working.</SPAN></P><P><SPAN style="font-size: 12pt;"><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/179066_pastedImage_1.png" style="max-height: 900px; max-width: 1200px;" /></SPAN></P><P></P><P></P></BODY></HTML> Mon, 09 Oct 2017 17:01:40 GMT MalcolmCICWF 2017-10-09T17:01:40Z Conditional Show Dimension GetSelectedCount (1 selection) https://community.qlik.com/t5/QlikView/Conditional-Show-Dimension-GetSelectedCount-1-selection/m-p/1421017#M428717 <HTML><HEAD></HEAD><BODY><P>Qlik Community,</P><P></P><P>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...</P><P><SPAN style="font-size: 12pt;">=</SPAN><SPAN style="font-size: 12pt;"><SPAN style="color: #0000ff;">if</SPAN>(<SPAN style="color: #0000ff;">GetSelectedCount</SPAN>(<SPAN style="color: #800000;">Date</SPAN>)=1,<SPAN style="color: #800000;">PoolID</SPAN></SPAN><SPAN style="font-size: 12pt;">) </SPAN></P><P></P><P><SPAN style="font-size: 12pt;">It seems easy, but isn't working.</SPAN></P><P><SPAN style="font-size: 12pt;"><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/179066_pastedImage_1.png" style="max-height: 900px; max-width: 1200px;" /></SPAN></P><P></P><P></P></BODY></HTML> Mon, 09 Oct 2017 17:01:40 GMT https://community.qlik.com/t5/QlikView/Conditional-Show-Dimension-GetSelectedCount-1-selection/m-p/1421017#M428717 MalcolmCICWF 2017-10-09T17:01:40Z Re: Conditional Show Dimension GetSelectedCount (1 selection) https://community.qlik.com/t5/QlikView/Conditional-Show-Dimension-GetSelectedCount-1-selection/m-p/1421018#M428718 <HTML><HEAD></HEAD><BODY><P>May be try with just this as your dimension</P><P></P><P><STRONG>PoolID</STRONG></P><P></P><P>and then use condition on your dimension</P><P><STRONG>GetSelectedCount(Date) = 1</STRONG></P><P></P><P>or</P><P></P><P><STRONG>Count(DISTINCT Date) = 1</STRONG></P></BODY></HTML> Mon, 09 Oct 2017 17:08:20 GMT https://community.qlik.com/t5/QlikView/Conditional-Show-Dimension-GetSelectedCount-1-selection/m-p/1421018#M428718 sunny_talwar 2017-10-09T17:08:20Z Re: Conditional Show Dimension GetSelectedCount (1 selection) https://community.qlik.com/t5/QlikView/Conditional-Show-Dimension-GetSelectedCount-1-selection/m-p/1421019#M428719 <HTML><HEAD></HEAD><BODY><P>wow I was making things too complicated, thanks</P></BODY></HTML> Mon, 09 Oct 2017 18:39:51 GMT https://community.qlik.com/t5/QlikView/Conditional-Show-Dimension-GetSelectedCount-1-selection/m-p/1421019#M428719 MalcolmCICWF 2017-10-09T18:39:51Z