Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
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
Anonymous
Not applicable
Author

Hi,

If the Sites are fixed (No change in future), you can use Combo chart and add individual expression for each Sites (Bar) and one expression for Total (Symbol).

Thanks

tresesco
MVP
MVP

Rachel,

I remeber that me and couple of other guys replied to this same requirement from you. Could you get that thread back? The previous discussion could help others to identify the issue properly and help you precisely. To say, a fresh thread is not always good.

Not applicable
Author

But if I do that the bars are grouped by site and MonthYear...

Not applicable
Author

Hey thanks but unfortunately I can open the qlikview files...

ThornOfCrowns
Specialist II
Specialist II

The other thread mentioned by tresesco is here: http://community.qlik.com/thread/122101

ThornOfCrowns
Specialist II
Specialist II

Are you using Personal Edition, or is it another issue preventing you from opening the files?

Not applicable
Author

Yeah, I'm using Personal Edition.

tresesco
MVP
MVP

See the screen shots attached.

Not applicable
Author

Hey thanks so much, but I need to be like this (grouped by monthyear):

Untitled.png