topic Line break in a cell of pivot table in App Development

Line break in a cell of pivot table

chriys1337 — Mon, 22 Nov 2021 13:15:26 GMT

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

Re: Line break in a cell of pivot table

Or — Mon, 22 Nov 2021 14:10:27 GMT

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).