1 Reply Latest reply: Nov 27, 2017 3:56 AM by chitraxi raj RSS

    How to add new Line in cell

    chitraxi raj

      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

       

      CustomerTotal 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?