https://community.qlik.com/t5/QlikView/How-to-exclude-the-duplicated-text-In-list-box/m-p/263513#M1182137 <HTML><HEAD></HEAD><BODY><P> Thank you Trim (Field ) worked <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 29 Nov 2011 10:12:41 GMT Anonymous 2011-11-29T10:12:41Z https://community.qlik.com/t5/QlikView/How-to-exclude-the-duplicated-text-In-list-box/m-p/263511#M1182135 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am taking the list box where the data is coming two times for the same item. Suppose we have two country INDIA and US then it is showing INDIA INDIA two times and US US two time.</P><P></P><P>I need only one time INDIA AND US.</P><P></P><P>best ,</P><P>skumar</P></BODY></HTML> Tue, 29 Nov 2011 09:38:54 GMT https://community.qlik.com/t5/QlikView/How-to-exclude-the-duplicated-text-In-list-box/m-p/263511#M1182135 Anonymous 2011-11-29T09:38:54Z https://community.qlik.com/t5/QlikView/How-to-exclude-the-duplicated-text-In-list-box/m-p/263512#M1182136 <HTML><HEAD></HEAD><BODY><P>Use trim(field)</P><P></P><P></P><P>or use distinct </P></BODY></HTML> Tue, 29 Nov 2011 09:53:00 GMT https://community.qlik.com/t5/QlikView/How-to-exclude-the-duplicated-text-In-list-box/m-p/263512#M1182136 SunilChauhan 2011-11-29T09:53:00Z https://community.qlik.com/t5/QlikView/How-to-exclude-the-duplicated-text-In-list-box/m-p/263513#M1182137 <HTML><HEAD></HEAD><BODY><P> Thank you Trim (Field ) worked <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 29 Nov 2011 10:12:41 GMT https://community.qlik.com/t5/QlikView/How-to-exclude-the-duplicated-text-In-list-box/m-p/263513#M1182137 Anonymous 2011-11-29T10:12:41Z