topic Showing multiple values in one field in QlikView https://community.qlik.com/t5/QlikView/Showing-multiple-values-in-one-field/m-p/166932#M38691 <HTML><HEAD></HEAD><BODY><P>Perfect!! Thank you!!</P></BODY></HTML> Thu, 17 Mar 2011 16:28:22 GMT Dayna 2011-03-17T16:28:22Z Showing multiple values in one field https://community.qlik.com/t5/QlikView/Showing-multiple-values-in-one-field/m-p/166930#M38689 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P>I have a straight table that shows information for a sales order, but the item may belong to more than one site.. Within QV, if the row has more than one value it produces a null ( - ) value in the cell. I would like to concatenate the values and show both.. How would I do this?</P><P>Any help you could provide would be appreciated!!</P><P>Many thanks,<BR />Dayna</P></BODY></HTML> Thu, 17 Mar 2011 16:09:07 GMT https://community.qlik.com/t5/QlikView/Showing-multiple-values-in-one-field/m-p/166930#M38689 Dayna 2011-03-17T16:09:07Z Showing multiple values in one field https://community.qlik.com/t5/QlikView/Showing-multiple-values-in-one-field/m-p/166931#M38690 <HTML><HEAD></HEAD><BODY><P>Hello Dayna,</P><P>You can use the Concat() aggregation function so</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">Concat(DISTINCT FieldWithMultipleValues, ',')</PRE></BLOCKQUOTE><BR /><BR /> <P>Hope that helps</P></BODY></HTML> Thu, 17 Mar 2011 16:22:00 GMT https://community.qlik.com/t5/QlikView/Showing-multiple-values-in-one-field/m-p/166931#M38690 Miguel_Angel_Baeyens 2011-03-17T16:22:00Z Showing multiple values in one field https://community.qlik.com/t5/QlikView/Showing-multiple-values-in-one-field/m-p/166932#M38691 <HTML><HEAD></HEAD><BODY><P>Perfect!! Thank you!!</P></BODY></HTML> Thu, 17 Mar 2011 16:28:22 GMT https://community.qlik.com/t5/QlikView/Showing-multiple-values-in-one-field/m-p/166932#M38691 Dayna 2011-03-17T16:28:22Z