Expressions for New Line

[shatings]

I'm completely new to QLIK. I have a field with multiple items separated by a semicolon. Ex. dog; cat; fish;etc (sometimes up to 50 items per row of data). How can I add an expression in QlikView to change each semicolon into a new line? I want it to look like this in my final excel formatted report from Nprinting:

dog

cat

fish

Can you please also explain really quickly on which sheet object would be best and where to insert the expression? Thank you!

[QFabian · Accepted solution]

Hi @shatings , you can use SUBFIELD Qlik function.

It is always recommended to do this kind of transformation in script, not in charts.

Here an example :

[shatings]

Thank you so much. So when I enter the command into the script, should I expect that second box you have to pop up with each animal on a new line? Or would I have to load that in to Nprinting?

[MayilVahanan]

Hi @shatings 

You need to do in scripting part of your nprinting connection file.

And use the new field in Nprinting excel format file to generate the report.