topic Re: Text in chart in QlikView

Text in chart

Tue, 08 Apr 2014 12:42:05 GMT

Hi everyone,

I have added a text in a line chart-properties-presentation-Add text

There i have added "concat(Product,', ')", so the values are coming but not all are displayed as i can't stretch the text box too much.

So is there any way to make the values display in the next line so that all values can be shown and also to have a vertical or horizontal scroll-bar in it??

PLEASE HELP.

Thanks in advance.

Re: Text in chart

sivarajs — Tue, 08 Apr 2014 12:59:18 GMT

In presentation check the multiline settings ( wrap header text).

Else try giving carriage return between text like 'text 1'&chr(13)&'text 2'

Re: Text in chart

Tue, 08 Apr 2014 13:05:35 GMT

That is for list box and multi box but i want it for text box inside the chart.

Re: Text in chart

Tue, 08 Apr 2014 13:14:38 GMT

If you add Text in 'Text in Chart' option you won't get the scroll bar.

There is one work around for this .

Take one text box and add your expression in it and check the Horizontal scroll bar option.

So it will give horizontal scroll if there r multiple values.

Hope this will help you..!

Re: Text in chart

rwunderlich — Tue, 08 Apr 2014 13:16:53 GMT

You can use a newline character as your delimiter.

concat(DISTINCT Product,chr(10))

That will place each product on a new line, and you may be able to size the text box to fit (Press Ctrtl-Shift while in the chart and drag the box size). There is no way I know of to get a scroll bar.

As an alternative, you may want to put the expression in a Text Object and place that on top of the chart.

-Rob

Re: Text in chart

c_gilbert — Tue, 08 Apr 2014 13:19:48 GMT

I don't think you can add a scroll bar to the text in chart, but I've used the 'carriage return' code before to move text to the line below when it is too long. For example:

='Text line 1'

& chr(13) & chr(10)

&'Text line 2'

Re: Text in chart

Tue, 08 Apr 2014 14:07:01 GMT

Yeah, I can do that but i have to export chart along with the text.

So, if i take another object i can't export both altogether. So I have to go for it.