topic Re: Concat with Line Feed ? in QlikView https://community.qlik.com/t5/QlikView/Concat-with-Line-Feed/m-p/496166#M548923 <HTML><HEAD></HEAD><BODY><P>This seemed to do the trick. Nice workaround. </P></BODY></HTML> Fri, 10 Jan 2014 16:53:07 GMT b_garside 2014-01-10T16:53:07Z Concat with Line Feed ? https://community.qlik.com/t5/QlikView/Concat-with-Line-Feed/m-p/496159#M548916 <HTML><HEAD></HEAD><BODY><P>Hi I need to use <STRONG>Concat</STRONG> to show the values of a field using GetFieldSelections().</P><P></P><P>Im sure its a syntax issue with <SPAN style="color: #000000; font-family: 'Courier New'; font-size: 12px;">Chr(10)</SPAN>. I need the values to go to the next line due to space constraints.</P><P></P><P><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">Concat</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">(</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">GetFieldSelections</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">(</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">ContractNumber</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">),Chr(10) ) </SPAN></P><P><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"><BR /></SPAN></P><P><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"><BR /></SPAN></P></BODY></HTML> Fri, 10 Jan 2014 16:35:43 GMT https://community.qlik.com/t5/QlikView/Concat-with-Line-Feed/m-p/496159#M548916 b_garside 2014-01-10T16:35:43Z Re: Concat with Line Feed ? https://community.qlik.com/t5/QlikView/Concat-with-Line-Feed/m-p/496160#M548917 <HTML><HEAD></HEAD><BODY><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 9pt; font-family: 'Courier New'; color: blue;">Try Concat</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 9pt; font-family: 'Courier New'; color: black;">(</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 9pt; font-family: 'Courier New'; color: maroon;">ContractNumber</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 9pt; font-family: 'Courier New'; color: black;">,Chr(10))</SPAN></P><P><SPAN style="font-weight: inherit; font-style: inherit; font-size: 9pt; font-family: 'Courier New'; color: black;"><BR /></SPAN></P></BODY></HTML> Fri, 10 Jan 2014 16:40:43 GMT https://community.qlik.com/t5/QlikView/Concat-with-Line-Feed/m-p/496160#M548917 Gysbert_Wassenaar 2014-01-10T16:40:43Z Re: Concat with Line Feed ? https://community.qlik.com/t5/QlikView/Concat-with-Line-Feed/m-p/496161#M548918 <HTML><HEAD></HEAD><BODY><P>Try using a line break as shown, but with ContractNumber instead of Date:</P><P></P><P><IMG alt="Example.JPG.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/51340_Example.JPG.jpg" style="width: 620px; height: 522px;" /></P><P></P><P> </P><P></P></BODY></HTML> Fri, 10 Jan 2014 16:42:19 GMT https://community.qlik.com/t5/QlikView/Concat-with-Line-Feed/m-p/496161#M548918 2014-01-10T16:42:19Z Re: Concat with Line Feed ? https://community.qlik.com/t5/QlikView/Concat-with-Line-Feed/m-p/496162#M548919 <HTML><HEAD></HEAD><BODY><P>This works but list all the values rather just the few. </P></BODY></HTML> Fri, 10 Jan 2014 16:46:16 GMT https://community.qlik.com/t5/QlikView/Concat-with-Line-Feed/m-p/496162#M548919 b_garside 2014-01-10T16:46:16Z Re: Concat with Line Feed ? https://community.qlik.com/t5/QlikView/Concat-with-Line-Feed/m-p/496163#M548920 <HTML><HEAD></HEAD><BODY><P>It will list all the possible values of the field. Those would be the same values that getfieldselections would return if any values were selected in that field.</P></BODY></HTML> Fri, 10 Jan 2014 16:48:50 GMT https://community.qlik.com/t5/QlikView/Concat-with-Line-Feed/m-p/496163#M548920 Gysbert_Wassenaar 2014-01-10T16:48:50Z Re: Concat with Line Feed ? https://community.qlik.com/t5/QlikView/Concat-with-Line-Feed/m-p/496164#M548921 <HTML><HEAD></HEAD><BODY><P>You would need a DISTINCT.&nbsp; Concat<SPAN style="color: black; font-family: 'Courier New'; font-size: 9pt; font-style: inherit; font-weight: inherit;">(DISTINCT </SPAN><SPAN style="color: maroon; font-family: 'Courier New'; font-size: 9pt; font-style: inherit; font-weight: inherit;">ContractNumber</SPAN><SPAN style="color: black; font-family: 'Courier New'; font-size: 9pt; font-style: inherit; font-weight: inherit;">,Chr(10))</SPAN></P></BODY></HTML> Fri, 10 Jan 2014 16:50:35 GMT https://community.qlik.com/t5/QlikView/Concat-with-Line-Feed/m-p/496164#M548921 2014-01-10T16:50:35Z Re: Concat with Line Feed ? https://community.qlik.com/t5/QlikView/Concat-with-Line-Feed/m-p/496165#M548922 <HTML><HEAD></HEAD><BODY><P>Ah, of course. Good point.</P></BODY></HTML> Fri, 10 Jan 2014 16:51:51 GMT https://community.qlik.com/t5/QlikView/Concat-with-Line-Feed/m-p/496165#M548922 Gysbert_Wassenaar 2014-01-10T16:51:51Z Re: Concat with Line Feed ? https://community.qlik.com/t5/QlikView/Concat-with-Line-Feed/m-p/496166#M548923 <HTML><HEAD></HEAD><BODY><P>This seemed to do the trick. Nice workaround. </P></BODY></HTML> Fri, 10 Jan 2014 16:53:07 GMT https://community.qlik.com/t5/QlikView/Concat-with-Line-Feed/m-p/496166#M548923 b_garside 2014-01-10T16:53:07Z