Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Text in chart

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.

6 Replies
Highlighted
Specialist II
Specialist II

Re: Text in chart

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

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

Highlighted
Not applicable

Re: Text in chart

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

Highlighted
Not applicable

Re: Text in chart

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..!

Highlighted
MVP & Luminary
MVP & Luminary

Re: Text in chart

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

Highlighted
Creator II
Creator II

Re: Text in chart

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'

Highlighted
Not applicable

Re: Text in chart

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.