topic Re: Alternate State in expression condition in QlikView https://community.qlik.com/t5/QlikView/Alternate-State-in-expression-condition/m-p/880108#M307149 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>SubstringCount(Concat(<SPAN style="color: #ff0000;">{StateA}</SPAN>Qtr, '|'), 'Q1')</STRONG></SPAN></P></BODY></HTML> Fri, 29 May 2015 17:10:39 GMT sunny_talwar 2015-05-29T17:10:39Z Alternate State in expression condition https://community.qlik.com/t5/QlikView/Alternate-State-in-expression-condition/m-p/880107#M307148 <HTML><HEAD></HEAD><BODY><P>Hi all</P><P></P><P>I have condition in Pivot expression</P><P></P><P>SubstringCount(Concat(Qtr, '|'), 'Q1)' </P><P>and List box for Qtr (StateA) , so If I select Q1 than particular column display otherwise not.</P><P></P><P>How do I apply StateA (Alternate State) in above Substring command line</P><P></P><P>Thanks</P><P></P><P><BR /> </P></BODY></HTML> Fri, 29 May 2015 16:59:45 GMT https://community.qlik.com/t5/QlikView/Alternate-State-in-expression-condition/m-p/880107#M307148 Anonymous 2015-05-29T16:59:45Z Re: Alternate State in expression condition https://community.qlik.com/t5/QlikView/Alternate-State-in-expression-condition/m-p/880108#M307149 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>SubstringCount(Concat(<SPAN style="color: #ff0000;">{StateA}</SPAN>Qtr, '|'), 'Q1')</STRONG></SPAN></P></BODY></HTML> Fri, 29 May 2015 17:10:39 GMT https://community.qlik.com/t5/QlikView/Alternate-State-in-expression-condition/m-p/880108#M307149 sunny_talwar 2015-05-29T17:10:39Z Re: Alternate State in expression condition https://community.qlik.com/t5/QlikView/Alternate-State-in-expression-condition/m-p/880109#M307150 <HTML><HEAD></HEAD><BODY><P>Add a closing single quote after Q1: SubstringCount(Concat(<SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #ff0000;">{StateA}</SPAN>Qtr, '|'), 'Q1')</P><P></P><P>Or try: max({StateA}match(Qtr,'Q1'))</P></BODY></HTML> Fri, 29 May 2015 17:14:41 GMT https://community.qlik.com/t5/QlikView/Alternate-State-in-expression-condition/m-p/880109#M307150 Gysbert_Wassenaar 2015-05-29T17:14:41Z Re: Alternate State in expression condition https://community.qlik.com/t5/QlikView/Alternate-State-in-expression-condition/m-p/880110#M307151 <HTML><HEAD></HEAD><BODY><P>Good catch <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 29 May 2015 17:15:48 GMT https://community.qlik.com/t5/QlikView/Alternate-State-in-expression-condition/m-p/880110#M307151 sunny_talwar 2015-05-29T17:15:48Z Re: Alternate State in expression condition https://community.qlik.com/t5/QlikView/Alternate-State-in-expression-condition/m-p/880111#M307152 <HTML><HEAD></HEAD><BODY><P>Works, Thanks guys <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 29 May 2015 17:17:34 GMT https://community.qlik.com/t5/QlikView/Alternate-State-in-expression-condition/m-p/880111#M307152 Anonymous 2015-05-29T17:17:34Z Re: Alternate State in expression condition https://community.qlik.com/t5/QlikView/Alternate-State-in-expression-condition/m-p/880112#M307153 <HTML><HEAD></HEAD><BODY><P>Works, Thanks guys <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 29 May 2015 17:17:47 GMT https://community.qlik.com/t5/QlikView/Alternate-State-in-expression-condition/m-p/880112#M307153 Anonymous 2015-05-29T17:17:47Z Re: Alternate State in expression condition https://community.qlik.com/t5/QlikView/Alternate-State-in-expression-condition/m-p/880113#M307154 <HTML><HEAD></HEAD><BODY><P>No problem <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 29 May 2015 17:19:31 GMT https://community.qlik.com/t5/QlikView/Alternate-State-in-expression-condition/m-p/880113#M307154 sunny_talwar 2015-05-29T17:19:31Z