topic Re: Add a Newline Character in QlikView

Add a Newline Character

Wed, 27 May 2015 09:17:56 GMT

Hi All,

I have a field value as ABC DEF.

I wish to convert it as ABC

DEF.

How can I replace the space between the words ABC and DEF with a newline character.

Thanks,

Asma

alexandros17 — Wed, 27 May 2015 09:19:51 GMT

replace ' ' with chr(10)

robert_mika — Wed, 27 May 2015 09:21:44 GMT

=Replace ('ABC DEF',' ',Chr(13))

petter — Wed, 27 May 2015 09:21:57 GMT

Where do you want to do it? In the load script or in the application in a chart at run-time?

Do you need it to show as separate rows in a table or is it in a Text Box?