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?
