Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
walterma
Contributor
Contributor

QlikSense: Carriage return each concatenated value in single cell

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:

1.png

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)

2.png

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?

Labels (1)
1 Reply
vinieme12
Champion III
Champion III

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

 

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.