topic Re: Alternate State in QlikView https://community.qlik.com/t5/QlikView/Alternate-State/m-p/973529#M332971 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P><STRONG>=Concat(DISTINCT {<SPAN style="color: #ff0000;">NameOfYourAlternateStateHere</SPAN>} [Week 1], ', ')</STRONG></P></BODY></HTML> Tue, 08 Dec 2015 16:03:50 GMT sunny_talwar 2015-12-08T16:03:50Z Alternate State https://community.qlik.com/t5/QlikView/Alternate-State/m-p/973528#M332970 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have to display the Selected Alternate state value in List box in Text box.</P><P></P><P>For example:</P><P></P><P>Week1&nbsp;&nbsp;&nbsp;&nbsp; week2(Alternate state of week1)</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp; </P><P>3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3</P><P>4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4</P><P></P><P>I have Selected 3 in Week2 list box and want to display it on text box, how to do?</P><P></P><P>Thanks</P><P>Manish</P></BODY></HTML> Tue, 08 Dec 2015 16:02:07 GMT https://community.qlik.com/t5/QlikView/Alternate-State/m-p/973528#M332970 Anonymous 2015-12-08T16:02:07Z Re: Alternate State https://community.qlik.com/t5/QlikView/Alternate-State/m-p/973529#M332971 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P><STRONG>=Concat(DISTINCT {<SPAN style="color: #ff0000;">NameOfYourAlternateStateHere</SPAN>} [Week 1], ', ')</STRONG></P></BODY></HTML> Tue, 08 Dec 2015 16:03:50 GMT https://community.qlik.com/t5/QlikView/Alternate-State/m-p/973529#M332971 sunny_talwar 2015-12-08T16:03:50Z Re: Alternate State https://community.qlik.com/t5/QlikView/Alternate-State/m-p/973530#M332972 <HTML><HEAD></HEAD><BODY><P>Thanks Sunny, it worked&nbsp; <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 08 Dec 2015 16:07:21 GMT https://community.qlik.com/t5/QlikView/Alternate-State/m-p/973530#M332972 Anonymous 2015-12-08T16:07:21Z Re: Alternate State https://community.qlik.com/t5/QlikView/Alternate-State/m-p/973531#M332973 <HTML><HEAD></HEAD><BODY><P>Awesome <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 08 Dec 2015 16:07:55 GMT https://community.qlik.com/t5/QlikView/Alternate-State/m-p/973531#M332973 sunny_talwar 2015-12-08T16:07:55Z