Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

display sum as data point above grouped bar chart

Hi, how do I sum up the 'inv turnover' (see in attached sample data) for each month and display it as a data point above the grouped bar chart like below? Each bar represents each site(see in attached sample data). Thanks.

Untitled.png

21 Replies
Not applicable
Author

Hi, so sorry I can only open files I created myself as I'm using Personal Edition. Do you mind sending me screen shots instead? Thanks so much.

Not applicable
Author

Hi,

Snapshot.PNG

In this, I have taken 2 dimensions, firstly "Month(MonthYear)&'-'&Mid(Year(MonthYear),3,4)" i.e. MonthYear and then Site. Then I have taken 2 Expressions:

1st one: "Sum: sum([inv turnover])"

2nd one: "Total: =sum(TOTAL<MonthYear>[inv turnover])"

So, in the chart, bar is displaying inv turnover for each Site for MonthYear and dot represent total turnover for each month i.e. why i have grouped it by MonthYear.

Thanks.