topic Expressions for New Line in QlikView

Expressions for New Line

shatings — Mon, 26 Jan 2026 16:26:21 GMT

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!

Re: Expressions for New Line

QFabian — Mon, 19 Apr 2021 23:50:30 GMT

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 :

Re: Expressions for New Line

shatings — Wed, 21 Apr 2021 16:42:25 GMT

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?

Re: Expressions for New Line

MayilVahanan — Thu, 22 Apr 2021 06:05:17 GMT

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.