This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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
=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?
Nobody can help me?
Thankyou in advance
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.
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.
swuehl ha scritto:
How can you get this result?
it may be useful...
You want to achieve something like attached?
I think it will work for dimension calculated
no need to write aggregate
hope this helps
see the attched file without aggr function
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...
Sure, this is what I was talking about initially. I have no solution for a chart like in your original post yet.
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.