topic Re: Remove empty line from a string in QlikView

Remove empty line from a string

kinjal1645 — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I have below expression displaying required data BUT with empty line at the beginning.

How do I remove empty line from the output string of below expression?

concat(distinct if(len([column1])<>0,[column1]&' * '&[column2])&' ' & chr(10))

Kindly help!

Thanks

sunny_talwar — Wed, 21 Mar 2018 19:47:48 GMT

Try this

Concat(DISTINCT If(Len([column1]) <> 0, [column1] & ' * ' & [column2]) & ' '), Chr(10))

vishsaggi — Wed, 21 Mar 2018 20:09:21 GMT

Can you share an example of whats your expected output?

kinjal1645 — Wed, 21 Mar 2018 20:49:22 GMT

Hello Tanay,

I tried this: Concat(DISTINCT If(Len([column1]) <> 0, [column1] & ' * ' & [column2]) & ' ', Chr(10))

But it did not work, still giving empty line at the beginning.

vishsaggi — Wed, 21 Mar 2018 21:16:38 GMT

Did you try exactly the expression suggested by Sunny? You are missing a bracket after & ' ')

kinjal1645 — Wed, 21 Mar 2018 21:24:01 GMT

That seems to be an extra bracket. Hence I mentioned my expression while replying to him

vishsaggi — Wed, 21 Mar 2018 21:33:12 GMT

try this?

= Concat(DISTINCT If(Len([column1]) <> 0, [column1] & ' * ' & [column2] & ' '), Chr(10))

wdchristensen — Wed, 21 Mar 2018 21:56:13 GMT

You expression is causing the empty line with the "new line" character.

concat(distinct if(len([column1])<>0,[column1]&' * '&[column2])&' ' & chr(10))

Try:

concat(distinct if(len([column1])<>0,[column1]&' * '&[column2]), '')

kinjal1645 — Wed, 21 Mar 2018 22:14:55 GMT

This works! It was the bracket.
Thank you