QlikSense: Carriage return each concatenated value in single cell

[walterma]

have 3 columns that contain a concatenated output. For example, here's one output as it exists as a SQL result: Baclofen (0 mCg/mL) Baclofen (380 mCg/mL) Bupivacaine HCl (5 mg/mL) HYDROmorphone HCl (6.6 mg/mL)

So what it currently looks like in QlikSense:

And what I want it to look like, after shrinking the column width, but of course the issues are:

1. Column width based on values varies, so this won't work for every cell, router login 10.0.0.1
2. It cuts off the last value in this example (the HYDROmorphone HCl)

Is there a way to format Qlik so that each of these values naturally goes to the next line router ip 192.168.0.1 and they all sit cleanly in the same cell?

[vinieme12]

use Subfield() to split the values into a new row

https://help.qlik.com/en-US/qlikview/May2023/Subsystems/Client/Content/QV_QlikView/Scripting/StringF...

or try this trick

https://community.qlik.com/t5/Qlik-Sense-Documents/Multiple-lines-in-Pivot-and-Straight-table-cells-...