Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
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
Highlighted
Specialist II
Specialist II

Hi,

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

HTH

André Gomes

Highlighted
Partner
Partner

Hi Jhansi,

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

Highlighted
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

Highlighted
Not applicable


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.

Highlighted
Not applicable

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

Highlighted
Not applicable

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?

Highlighted
Not applicable

Hi,

I have attached sample file to check.

Highlighted
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

Highlighted
Not applicable

!Hi,

not sure but you can try following solutuin