topic Need Help in QlikView https://community.qlik.com/t5/QlikView/Need-Help/m-p/899204#M993149 <HTML><HEAD></HEAD><BODY><P>HI Community,</P><P></P><P>In&nbsp; my text box i have used CONCAT function.</P><P></P><P>=Concat( if(($(vVariable)&gt;=Date-10)&nbsp; and ($(vVariable)&lt;=Date-5), EmpID),&nbsp; ',')</P><P></P><P>This expression working fine, but i want to show distinct values in my TextBox...</P><P></P><P>Thanks in Advance..............</P></BODY></HTML> Fri, 17 Jul 2015 15:46:27 GMT paulwalker 2015-07-17T15:46:27Z Need Help https://community.qlik.com/t5/QlikView/Need-Help/m-p/899204#M993149 <HTML><HEAD></HEAD><BODY><P>HI Community,</P><P></P><P>In&nbsp; my text box i have used CONCAT function.</P><P></P><P>=Concat( if(($(vVariable)&gt;=Date-10)&nbsp; and ($(vVariable)&lt;=Date-5), EmpID),&nbsp; ',')</P><P></P><P>This expression working fine, but i want to show distinct values in my TextBox...</P><P></P><P>Thanks in Advance..............</P></BODY></HTML> Fri, 17 Jul 2015 15:46:27 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/899204#M993149 paulwalker 2015-07-17T15:46:27Z Re: Need Help https://community.qlik.com/t5/QlikView/Need-Help/m-p/899205#M993150 <HTML><HEAD></HEAD><BODY><P>Use DISTINCT then</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">=Concat(<STRONG>DISTINCT</STRONG> if(($(vVariable)&gt;=Date-10)&nbsp; and ($(vVariable)&lt;=Date-5), EmpID),&nbsp; ',')</SPAN></P></BODY></HTML> Fri, 17 Jul 2015 15:47:57 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/899205#M993150 sunny_talwar 2015-07-17T15:47:57Z Re: Need Help https://community.qlik.com/t5/QlikView/Need-Help/m-p/899206#M993151 <HTML><HEAD></HEAD><BODY><P>Actually i have tried DISTINCT, It was throw Expression Error...</P><P>i don't know what happend.... now it's working....</P></BODY></HTML> Fri, 17 Jul 2015 15:56:34 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/899206#M993151 paulwalker 2015-07-17T15:56:34Z Re: Need Help https://community.qlik.com/t5/QlikView/Need-Help/m-p/899207#M993152 <HTML><HEAD></HEAD><BODY><P>Great <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>Would you mind closing this thread by marking the correct answer.</P><P></P><P>Best,</P><P>Sunny</P></BODY></HTML> Fri, 17 Jul 2015 15:59:42 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/899207#M993152 sunny_talwar 2015-07-17T15:59:42Z