topic Re: Alternate State on GetSelectedCount in QlikView https://community.qlik.com/t5/QlikView/Alternate-State-on-GetSelectedCount/m-p/845324#M296827 <HTML><HEAD></HEAD><BODY><P>Starting with <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"> QV 11.20 SR8 the getselectedcount function supports an alternate state name as <EM>third</EM> parameter:</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">=if(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">GetSelectedCount(MarketName,0,'<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333330154419px;">GroupA</SPAN>')+GetSelectedCount(Facility<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">,0,'</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333330154419px;">GroupA</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">'</SPAN>)&gt;0,1,0)</SPAN><BR /></SPAN></P></BODY></HTML> Wed, 17 Jun 2015 18:48:25 GMT Gysbert_Wassenaar 2015-06-17T18:48:25Z Alternate State on GetSelectedCount https://community.qlik.com/t5/QlikView/Alternate-State-on-GetSelectedCount/m-p/845323#M296826 <HTML><HEAD></HEAD><BODY><P>I have a variable defined as:</P><P></P><P>=GetSelectedCount(MarketName)+GetSelectedCount(Facility)&gt;0</P><P></P><P>Which works correctly if the state is inherited.&nbsp; I want to use the states GroupA and GroupB instead of inherited in two different variables.&nbsp; Although adding the set doesn't seem to work for me:</P><P></P><P><SPAN style="font-size: 13.3333330154419px;">=GetSelectedCount({GroupA&lt;{}&gt;}MarketName)+GetSelectedCount(<SPAN style="font-size: 13.3333330154419px;">GroupA&lt;{}&gt;}</SPAN>Facility)&gt;0</SPAN></P><P><SPAN style="font-size: 13.3333330154419px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333330154419px;">What am I doing incorrectly?<BR /></SPAN></P></BODY></HTML> Wed, 17 Jun 2015 18:35:49 GMT https://community.qlik.com/t5/QlikView/Alternate-State-on-GetSelectedCount/m-p/845323#M296826 NickHoff 2015-06-17T18:35:49Z Re: Alternate State on GetSelectedCount https://community.qlik.com/t5/QlikView/Alternate-State-on-GetSelectedCount/m-p/845324#M296827 <HTML><HEAD></HEAD><BODY><P>Starting with <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"> QV 11.20 SR8 the getselectedcount function supports an alternate state name as <EM>third</EM> parameter:</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">=if(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">GetSelectedCount(MarketName,0,'<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333330154419px;">GroupA</SPAN>')+GetSelectedCount(Facility<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">,0,'</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333330154419px;">GroupA</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">'</SPAN>)&gt;0,1,0)</SPAN><BR /></SPAN></P></BODY></HTML> Wed, 17 Jun 2015 18:48:25 GMT https://community.qlik.com/t5/QlikView/Alternate-State-on-GetSelectedCount/m-p/845324#M296827 Gysbert_Wassenaar 2015-06-17T18:48:25Z