topic Re: InputBox - Predefined Values with Commas in QlikView https://community.qlik.com/t5/QlikView/InputBox-Predefined-Values-with-Commas/m-p/631573#M1090443 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>Try to use other symbol in the Concact</P><P>OR replace ", with . like (=concat(distinct REPLACE(Categories,'",','".'),'.'))</P></BODY></HTML> Thu, 29 May 2014 01:32:55 GMT SergeyMak 2014-05-29T01:32:55Z InputBox - Predefined Values with Commas https://community.qlik.com/t5/QlikView/InputBox-Predefined-Values-with-Commas/m-p/631572#M1090442 <HTML><HEAD></HEAD><BODY><P>Hi Everyone,</P><P></P><P>So I created an InputBox and chose to have predefined values with a drop down - it worked perfectly except a few of the values in Categories have commas in them so the drop down is separating them.</P><P></P><P>Any ideas?</P><P></P><P>Thanks,</P><P>J</P><P></P><P></P><P><STRONG>Expression:</STRONG>&nbsp; </P><P></P><P>=concat(distinct Categories,',')</P><P></P><P></P><P><STRONG>Categories:</STRONG></P><P></P><P>"Shirts", "Pants, short", "Pants, long"</P><P></P><P></P><P><STRONG>What I'm getting in the drop-down:</STRONG></P><P></P><P>Shirts, Pants, short, long</P></BODY></HTML> Wed, 28 May 2014 21:50:51 GMT https://community.qlik.com/t5/QlikView/InputBox-Predefined-Values-with-Commas/m-p/631572#M1090442 2014-05-28T21:50:51Z Re: InputBox - Predefined Values with Commas https://community.qlik.com/t5/QlikView/InputBox-Predefined-Values-with-Commas/m-p/631573#M1090443 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>Try to use other symbol in the Concact</P><P>OR replace ", with . like (=concat(distinct REPLACE(Categories,'",','".'),'.'))</P></BODY></HTML> Thu, 29 May 2014 01:32:55 GMT https://community.qlik.com/t5/QlikView/InputBox-Predefined-Values-with-Commas/m-p/631573#M1090443 SergeyMak 2014-05-29T01:32:55Z