Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

LineBreak in dimension (Bar Chart)

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

Example.JPG

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?

9 Replies
Not applicable
Author

Nobody can help me?

Thankyou in advance

L.

swuehl
MVP
MVP

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.

Not applicable
Author

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

You want to achieve something like attached?

IamBack
Champion
Champion

hello steafen,

I think it will work for dimension calculated

=CustomerName&chr(10)&CustomerNO

no need to write aggregate

hope this helps

IamBack
Champion
Champion

see the attched file without aggr function

Not applicable
Author

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

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

NikosSpanos
Contributor III
Contributor III

Hello @IamBack , 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.