topic Re: field value concatenation in QlikView https://community.qlik.com/t5/QlikView/field-value-concatenation/m-p/769224#M661874 <HTML><HEAD></HEAD><BODY><P>Magique !!!!!</P><P></P><P>Thank you very much !!!!!!!!!!!!!!</P><P></P><P>PS: now, i have to spend some time to understand this formula <IMG src="https://community.qlik.com/legacyfs/online/emoticons/laugh.png" /></P></BODY></HTML> Mon, 09 Mar 2015 17:30:22 GMT demoustier 2015-03-09T17:30:22Z field value concatenation https://community.qlik.com/t5/QlikView/field-value-concatenation/m-p/769221#M661871 <HTML><HEAD></HEAD><BODY><P>Good day QViewer !</P><P></P><P>I have a list of unique value:</P><P>F1</P><P>a</P><P>b</P><P>c</P><P>d</P><P>e</P><P>f</P><P>....</P><P></P><P>and i'd like to have a unique value = "a"|"b"|"c"|"..."</P><P></P><P>I tried with previous, Peek, loop,....without any success.</P><P></P><P>If somebody have an idea.....</P><P></P><P>Kind regards</P></BODY></HTML> Mon, 09 Mar 2015 17:12:47 GMT https://community.qlik.com/t5/QlikView/field-value-concatenation/m-p/769221#M661871 demoustier 2015-03-09T17:12:47Z Re: field value concatenation https://community.qlik.com/t5/QlikView/field-value-concatenation/m-p/769222#M661872 <HTML><HEAD></HEAD><BODY><P>Try concat(chr(34) &amp; F1&nbsp; &amp; chr(34), '|')</P><P></P><P>Example:</P><P>LOAD concat(chr(34) &amp; F1&nbsp; &amp; chr(34), '|') AS List INLINE [</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">F1</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">a</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">b</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">c</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">d</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">e</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">f</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">];</P></BODY></HTML> Mon, 09 Mar 2015 17:24:26 GMT https://community.qlik.com/t5/QlikView/field-value-concatenation/m-p/769222#M661872 Gysbert_Wassenaar 2015-03-09T17:24:26Z Re: field value concatenation https://community.qlik.com/t5/QlikView/field-value-concatenation/m-p/769223#M661873 <HTML><HEAD></HEAD><BODY><P>You can use concat:</P><P></P><P>chr(34) &amp; concat(distinct F1, chr(34) &amp;'|' &amp; chr(34)) &amp; chr(34)</P></BODY></HTML> Mon, 09 Mar 2015 17:27:58 GMT https://community.qlik.com/t5/QlikView/field-value-concatenation/m-p/769223#M661873 Anonymous 2015-03-09T17:27:58Z Re: field value concatenation https://community.qlik.com/t5/QlikView/field-value-concatenation/m-p/769224#M661874 <HTML><HEAD></HEAD><BODY><P>Magique !!!!!</P><P></P><P>Thank you very much !!!!!!!!!!!!!!</P><P></P><P>PS: now, i have to spend some time to understand this formula <IMG src="https://community.qlik.com/legacyfs/online/emoticons/laugh.png" /></P></BODY></HTML> Mon, 09 Mar 2015 17:30:22 GMT https://community.qlik.com/t5/QlikView/field-value-concatenation/m-p/769224#M661874 demoustier 2015-03-09T17:30:22Z