Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Bar Chart expression


Hi Team,

I want to show the Total Value for Each month at the top of the each bar. Eg: 1000 - at 0314 bar , 2000  - 0614 bar etc..

Bar chart.png

Can this possible?

1 Solution

Accepted Solutions
JonnyPoole
Employee
Employee

ok. i got interested

i put this expression in the subtitle to space out the totals horizontally across the top

= concat( aggr(sum(total <ReportMonth> Value),ReportMonth) ,  Repeat(' ',160/count( DISTINCT ReportMonth)) ,ReportMonth)

Capture.PNG

hold down the CTRL/SHIFT key and click the chart ,you will see red lines and you can move the legend, title around as you see fit. i found the spacing works better if the legend is NOT on the side but play with it, maybe you can get it to work by pushing the title a little left off center. 

in the expression above play with the '160' number if you resize the chart to space the totals right.

good luck !

View solution in original post

15 Replies
agomes1971
Specialist II
Specialist II

Hi,

play with the y-axis and maybe changing the units...

HTH

André Gomes

jpenuliar
Partner - Specialist III
Partner - Specialist III

Hi Jhansi,

you will have to untick "Plot values inside Segments" to show Values on top of Bars

JonnyPoole
Employee
Employee

Well - its a little tricky because you can either have all the data points inside the segments or on top and not both.  I don't see a good way around it.  If you are desperate you can go with the total kluge idea of overlaying 2 charts (see below and attached) .  It may look ok but you'll spend a lot of time trying to get the charts working perfectly in unison so only do this if its impossible to visualize any other better way .

Capture.PNG

Not applicable
Author


I want to show Tota sum up value of all segments at the Top of each bar i.e Total Amount for all categories for each month.

Not applicable
Author

Yes, We can achieve in this way. the problem is they will copy this graph as a Image , sure it is not going to copy Total Value at that time ..

Not applicable
Author

If i go for combo chart and having Second expression in chart might solve the problem. I used Aggr(sum(Total), Report_Month), but leading to entirely different view... can anyone try this?

Not applicable
Author

Hi,

I have attached sample file to check.

JonnyPoole
Employee
Employee

didn't see the file attached to attach:

1. click the full thread link:   Bar Chart expression

2. then hit 'reply'

3. then hit 'advanced editor'

-> attach the file and post

Not applicable
Author

!Hi,

not sure but you can try following solutuin