topic Re: Line breaks --> No indication for truncated text in QlikView

Line breaks --> No indication for truncated text

pennetzdorfer — Wed, 24 Jul 2013 10:27:03 GMT

If text length exceeds the available column width, the text gets truncated - which is usually indicated by 3 dots (...)

BUT: if the text contains line breaks, Qlikview doesn't show the 3 dots (...). Hence, the user has no evidence that there is some additional "hidden" information unless he hovers over the value. Is there a way to get the 3 dots?!

Please see attached qvw.

Regards,

Florian

Re: Line breaks --> No indication for truncated text

Gysbert_Wassenaar — Wed, 24 Jul 2013 10:46:54 GMT

You could remove the line breaks from the string using replace

Re: Line breaks --> No indication for truncated text

pennetzdorfer — Wed, 24 Jul 2013 13:42:46 GMT

Thanks Gysbert, but the text should stay as it is (line breaks are necessary in that specific case) ...

Any other ideas?

Re: Line breaks --> No indication for truncated text

Gysbert_Wassenaar — Wed, 24 Jul 2013 13:50:57 GMT

Increase the height of the cells?

Create an extra field substringcount(Text, chr(10)) as Lines and show that in the table too?

Just live with it and explain it to your users?