topic Re: How to add new Line in cell in App Development https://community.qlik.com/t5/App-Development/How-to-add-new-Line-in-cell/m-p/1376254#M31141 <HTML><HEAD></HEAD><BODY><P>New Line thing wont work in table..</P><P>It will only work with Text Object or KPI Object</P></BODY></HTML> Mon, 27 Nov 2017 08:59:34 GMT shraddha_g 2017-11-27T08:59:34Z How to add new Line in cell https://community.qlik.com/t5/App-Development/How-to-add-new-Line-in-cell/m-p/1376253#M31140 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have two&nbsp; three Fields in my datamodel. FirstName , LastName and City, Sales. </P><P></P><P>I want to create chart using table of two column as Follows</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Customer</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Total Sale</TH></TR><TR><TD style="padding: 2px;"><P>[FirstName]</P><P>[LastName]</P><P>[City]</P></TD><TD style="padding: 2px;">Sum(Sales)</TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR></TBODY></TABLE><P></P><P>I have to concat 3 dimensions in one column in one Column, each dimension in a new line. </P><P>I am Using =<STRONG>[FirstName] &amp; chr(13) &amp; [LastName] &amp; chr(13) &amp; [City]</STRONG></P><P>values are concating but new line is not coming in qlik sense.</P><P>I tried chr(10) and '\n' instead on chr(13) but all of them are not working.</P><P>I have to achieve this without writing any script on the database. Any suggestion for adding text in the new line?</P></BODY></HTML> Mon, 27 Nov 2017 08:56:18 GMT https://community.qlik.com/t5/App-Development/How-to-add-new-Line-in-cell/m-p/1376253#M31140 Anonymous 2017-11-27T08:56:18Z Re: How to add new Line in cell https://community.qlik.com/t5/App-Development/How-to-add-new-Line-in-cell/m-p/1376254#M31141 <HTML><HEAD></HEAD><BODY><P>New Line thing wont work in table..</P><P>It will only work with Text Object or KPI Object</P></BODY></HTML> Mon, 27 Nov 2017 08:59:34 GMT https://community.qlik.com/t5/App-Development/How-to-add-new-Line-in-cell/m-p/1376254#M31141 shraddha_g 2017-11-27T08:59:34Z