How to add new Line in cell

[Anonymous]

Hi All,

I have two  three Fields in my datamodel. FirstName , LastName and City, Sales.

I want to create chart using table of two column as Follows

Customer	Total Sale
[FirstName] [LastName] [City]	Sum(Sales)

I have to concat 3 dimensions in one column in one Column, each dimension in a new line.

I am Using =[FirstName] & chr(13) & [LastName] & chr(13) & [City]

values are concating but new line is not coming in qlik sense.

I tried chr(10) and '\n' instead on chr(13) but all of them are not working.

I have to achieve this without writing any script on the database. Any suggestion for adding text in the new line?

[shraddha_g]

New Line thing wont work in table..

It will only work with Text Object or KPI Object