Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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
satyadev_j
Valued Contributor

Re: display sum as data point above grouped bar chart

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

MVP
MVP

Re: display sum as data point above grouped bar chart

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

Re: display sum as data point above grouped bar chart

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

Not applicable

Re: display sum as data point above grouped bar chart

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

thornofcrowns
Valued Contributor II

Re: display sum as data point above grouped bar chart

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

thornofcrowns
Valued Contributor II

Re: display sum as data point above grouped bar chart

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

Not applicable

Re: display sum as data point above grouped bar chart

Yeah, I'm using Personal Edition.

MVP
MVP

Re: Re: display sum as data point above grouped bar chart

See the screen shots attached.

Not applicable

Re: display sum as data point above grouped bar chart

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

Untitled.png