topic Re: LineBreak in dimension (Bar Chart) in QlikView

LineBreak in dimension (Bar Chart)

Thu, 05 Apr 2012 10:30:30 GMT

Hello everybody

I have a simple bar chart that shows me the top 20 customers.

The chart is very simple, and in the x axis i have the customer name.

Now, i would like to have not only the cutomer name, but even the selling agent and the department code, after a line break, as in the example

I tried to look in the dimensions options, building a Calculated Dimension, and it works fine, but i'm not able to insert the line break

tried with

=AcquisizioniRagioneSociale & '<br>' & CodArea

=AcquisizioniRagioneSociale & chr(10) & CodArea

but qlik doesn't insert any lineBreak, and i found no option to do this

Anybody can help me?

LineBreak in dimension (Bar Chart)

Tue, 10 Apr 2012 14:04:34 GMT

Nobody can help me?

Thankyou in advance

LineBreak in dimension (Bar Chart)

swuehl — Tue, 10 Apr 2012 14:18:17 GMT

For any reason, I am only able to get a line break when using the 'standard vertical' chart orientation in style tab and when using vertical or diagonal axis label in axis tab.

I wasn't able to get the line break when using a 'landscape' bar chart like in your screen shot above, too.

LineBreak in dimension (Bar Chart)

Tue, 10 Apr 2012 14:27:15 GMT

thankyou swuehl

swuehl ha scritto:
For any reason, I am only able to get a line break when using the 'standard vertical' chart orientation in style tab and when using vertical or diagonal axis label in axis tab.
I wasn't able to get the line break when using a 'landscape' bar chart like in your screen shot above, too.

How can you get this result?

it may be useful...

Re: LineBreak in dimension (Bar Chart)

swuehl — Tue, 10 Apr 2012 14:32:17 GMT

You want to achieve something like attached?

LineBreak in dimension (Bar Chart)

SunilChauhan — Tue, 10 Apr 2012 14:36:31 GMT

hello steafen,

I think it will work for dimension calculated

=CustomerName&chr(10)&CustomerNO

no need to write aggregate

hope this helps

Re: LineBreak in dimension (Bar Chart)

SunilChauhan — Tue, 10 Apr 2012 14:39:25 GMT

see the attched file without aggr function

Re: LineBreak in dimension (Bar Chart)

Tue, 10 Apr 2012 14:44:23 GMT

line break works well with and without aggr. This is the result I'm looking for..

but it doesn't work if the chart is horizontal...

Re: LineBreak in dimension (Bar Chart)

swuehl — Tue, 10 Apr 2012 14:48:19 GMT

Sure, this is what I was talking about initially. I have no solution for a chart like in your original post yet.

Re: LineBreak in dimension (Bar Chart)

NikosSpanos — Thu, 11 Mar 2021 08:00:22 GMT

Hello @SunilChauhan , Is this feasible with a scatter plot? Because I have created a bubble chart using scatter plot and when I try to use chr(10) in the expression below:

=Aggr(only([Customer]) & ': ' & chr(10) & Num(sum([Sales])/1000000000, '#.##0,##', ',', '.'), [Customer])

the line break does not work in the expression above.

Any suggestions would be much appreciated.