Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
chriys1337
Creator III
Creator III

Line break in a cell of pivot table

Hi,

 

I would like to have a line break in all cells of a pivot table:

 

Currently the values look like this: 

10% (2/20)

 

and I would like to add a line break:

10%

(2/20)

 

I already tried it with chr(10), chr(13) or <b>. In the datamodel that are two field which I concatenated:

Field1 & '(' & Field 2 ')' as NewField.

Can anybody please help? Thank you!

 

chriys

1 Reply
Or
MVP
MVP

As far as I know, there's no way to insert a new line into a measure value in a Qlik table or pivot table. This pops up once in a while but as far as I know nobody's suggested a working solution and nobody's posted an idea on the Ideation board to get it changed.

You can either use a third-party extension that supports this, or use a calculated dimension instead (dimensions do support line breaks inserted using e.g. chr(10).