topic Create comma-delimited list / combine row values in QlikView https://community.qlik.com/t5/QlikView/Create-comma-delimited-list-combine-row-values/m-p/150656#M28632 <HTML><HEAD></HEAD><BODY><P>Perfect - thanks.</P></BODY></HTML> Thu, 30 Jul 2009 04:26:08 GMT 2009-07-30T04:26:08Z Create comma-delimited list / combine row values https://community.qlik.com/t5/QlikView/Create-comma-delimited-list-combine-row-values/m-p/150654#M28630 <HTML><HEAD></HEAD><BODY><P>Suppose I have a COLORS table with these values that I load into QlikView:</P><P>RED<BR />YELLOW<BR />BLUE<BR />GREEN</P><P>How can I turn it into a comma delimited list, for example;</P><P>RED,YELLOW,BLUE,GREEN</P><P>(similar to what is discussed here) <A href="http://www.sqlbook.com/SQL/Create-comma-delimited-list-27.aspx">http://www.sqlbook.com/SQL/Create-comma-delimited-list-27.aspx</A></P><P>Suggestions? Is there a function that does this? Thanks in advance.</P></BODY></HTML> Thu, 30 Jul 2009 04:10:01 GMT https://community.qlik.com/t5/QlikView/Create-comma-delimited-list-combine-row-values/m-p/150654#M28630 2009-07-30T04:10:01Z Create comma-delimited list / combine row values https://community.qlik.com/t5/QlikView/Create-comma-delimited-list-combine-row-values/m-p/150655#M28631 <HTML><HEAD></HEAD><BODY><P>In an expression, you can use Concat.</P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">=concat(Color, ', ')</PRE></BLOCKQUOTE><BR /><BR /></BODY></HTML> Thu, 30 Jul 2009 04:14:24 GMT https://community.qlik.com/t5/QlikView/Create-comma-delimited-list-combine-row-values/m-p/150655#M28631 2009-07-30T04:14:24Z Create comma-delimited list / combine row values https://community.qlik.com/t5/QlikView/Create-comma-delimited-list-combine-row-values/m-p/150656#M28632 <HTML><HEAD></HEAD><BODY><P>Perfect - thanks.</P></BODY></HTML> Thu, 30 Jul 2009 04:26:08 GMT https://community.qlik.com/t5/QlikView/Create-comma-delimited-list-combine-row-values/m-p/150656#M28632 2009-07-30T04:26:08Z