topic Re: Line break in field title in QlikView

Line break in field title

Fri, 17 Jan 2014 14:50:11 GMT

Hey,

Right now, my field title displays as "Title Subtitle", but i'd like it to display as "Title [line break] Subtitle" so that the Subtitle only appears when I hover my pointer over the field box's title. In order to do this, I've been trying to create a variable as follows: set var= 'title' & chr(13) & 'subtitle' and then use SQL select item as var. This isn't working however, and I'm not sure why. The error message we receive is: Incorrect syntax near '&'.

We would really appreciate any help!

Re: Line break in field title

Anonymous — Fri, 17 Jan 2014 15:06:25 GMT

Stephen

Where do you wish to display this field title ?

In something like row headers on a Table Object or something else ?

Possible methods depend on where / how you wish to display it ?

Best Regards, Bill

Re: Line break in field title

Fri, 17 Jan 2014 15:13:12 GMT

Thanks for the response! I'd like to display the field title in a list box.

Re: Line break in field title

Anonymous — Fri, 17 Jan 2014 15:17:13 GMT

Stephen

In your List Box properties, Presentation tab under Multiline Settings would ticking Wrap Cell Text help ?

Best Regards, Bill

Re: Line break in field title

Anonymous — Fri, 17 Jan 2014 15:20:40 GMT

It is easy if you have Title and Subtitle as the separate fields in one table. List box should be calculated, using expression:

Title & chr(10) & Subtitle

Re: Line break in field title

Fri, 17 Jan 2014 15:23:50 GMT

The Wrap Cell option seems to create two lines for the data rather than the title. Is there any way to apply that only to the title?

Re: Line break in field title

Anonymous — Fri, 17 Jan 2014 15:39:53 GMT

Stephen

When you say 'title' with regards to a List Box do you mean the Caption at the top of the List Box ?

Best Regards, Bill

Re: Line break in field title

Fri, 17 Jan 2014 16:10:34 GMT

Yep

Re: Line break in field title

rwunderlich — Fri, 17 Jan 2014 16:52:32 GMT

I think it would be cumbersome to have the linebreak as part of the fieldname.

You can just change the Title property of the listbox to include the line break. Press the elipse button next to the Title property to enter the Expression Editor and enter:

Title

SubTitle

-Rob

Re: Line break in field title

akshaykhiste — Thu, 08 Aug 2019 14:45:53 GMT

Now we have feature to make chart header in multiple lines, in chart properties -> Presentation -> Multiline settings