LineBreak in dimension (Bar Chart)

[#1]

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

or

=AcquisizioniRagioneSociale & chr(10) & CodArea

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

Anybody can help me?

[#2]

Nobody can help me?

Thankyou in advance

L.

[swuehl]

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.

[#4]

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

[swuehl]

You want to achieve something like attached?

[SunilChauhan]

hello steafen,

I think it will work for dimension calculated

=CustomerName&chr(10)&CustomerNO

no need to write aggregate

hope this helps

[SunilChauhan]

see the attched file without aggr function

[#8]

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

[swuehl]

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

[NikosSpanos]

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.