topic Re: Line Break in Labels in QlikView

Line Break in Labels

peschu123 — Fri, 23 Aug 2013 10:16:42 GMT

Hi,

instead of using TOTALs in my straight table, I use labels like: ='Bearbeitungszeit ( ' & (sum(Bearbeitungszeit)) &' h )'

Table is format with wrapping of labels in 2 lines.

Is it possible to define fixed line breaks in the above example like (I use <br> html tag to show where the break should be):

='Bearbeitungszeit <br> ( ' & (sum(Bearbeitungszeit)) &' h )'

Thank you very much for any help

Re: Line Break in Labels

MayilVahanan — Fri, 23 Aug 2013 10:19:23 GMT

Try like this

='Bearbeitungszeit ' & Chr(10) &' ( ' & (sum(Bearbeitungszeit)) &' h )'

Re: Line Break in Labels

peschu123 — Fri, 23 Aug 2013 10:30:06 GMT

Thank you for the ultrafast reply...

It works very well, when the column is bigger than the part before the break ( kinda logic and obviously).

This is great for me. If you have a quick idea how to manage, to set the column width from 0 - Chr(10) it would be great. Even if the second line is longer than first.

That it looks like this:

Bearbeitungszeit

( 200.000 h /Mo..

But I assume this is not easily possible.