topic Re: How to split the field string and display in the same field? in QlikView

How to split the field string and display in the same field?

narayanaqlik — Wed, 23 May 2018 05:15:34 GMT

Hi All,

Have a nice day..!

i have one field in one of my report with huge length like <affhgg="123"Id="123gvn7558"><fujhhfjsh="0878"><invoice id="72468hjj">... so on nearly 10 to 15 times are there

So i want to display all values in the same field and same row but those are one by one like wrap text

InvoiceID

ID	Invoice ID
1	<affhgg="123"Id="123gvn7558"> <fujhhfjsh="0878"> <invoice id="72468hjj">
2	<affhgg="123"Id="123gvn7558"> <fujhhfjsh="0878"> <invoice id="72468hjj">

Invoice ID

<affhgg="123"Id="123gvn7558">

<fujhhfjsh="0878">

<affhgg="123"Id="123gvn7558">

<fujhhfjsh="0878">

<fujhhfjsh="0878">

...

so on so How ?

Thanks in advance

Re: How to split the field string and display in the same field?

tresB — Wed, 23 May 2018 05:24:27 GMT

Try incorporating new line character chr(10), like:

=Replace([Invoice ID], '><', '>'&chr(10)&'<')

and then use ,multi-line header setting in the chart.

Re: How to split the field string and display in the same field?

olivierrobin — Wed, 23 May 2018 06:56:05 GMT

hello

if '>' is the ending delimiter of the strings

try to replace '>' by '>' & chr(10)

so that each string appears on one line