topic Re: Re: display sum as data point above grouped bar chart in QlikView

display sum as data point above grouped bar chart

Tue, 17 Jun 2014 08:12:40 GMT

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.

Re: display sum as data point above grouped bar chart

Anonymous — Tue, 17 Jun 2014 08:28:06 GMT

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

Re: display sum as data point above grouped bar chart

tresB — Tue, 17 Jun 2014 08:35:12 GMT

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.

Re: display sum as data point above grouped bar chart

Tue, 17 Jun 2014 08:40:20 GMT

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

Re: display sum as data point above grouped bar chart

Tue, 17 Jun 2014 08:42:06 GMT

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

Re: display sum as data point above grouped bar chart

ThornOfCrowns — Tue, 17 Jun 2014 08:42:33 GMT

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

Re: display sum as data point above grouped bar chart

ThornOfCrowns — Tue, 17 Jun 2014 08:43:20 GMT

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

Re: display sum as data point above grouped bar chart

Tue, 17 Jun 2014 08:44:30 GMT

Yeah, I'm using Personal Edition.

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

tresB — Tue, 17 Jun 2014 08:58:02 GMT

See the screen shots attached.

Re: display sum as data point above grouped bar chart

Tue, 17 Jun 2014 09:04:44 GMT

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

Re: display sum as data point above grouped bar chart

Tue, 17 Jun 2014 09:07:24 GMT

Currently I have this:

Now I just need the sum for each month to be a data point on top. Thanks

Re: display sum as data point above grouped bar chart

ThornOfCrowns — Tue, 17 Jun 2014 09:09:06 GMT

Change the Dimension to:

=date(MonthYear,'MMM-YY')

Re: display sum as data point above grouped bar chart

Tue, 17 Jun 2014 09:13:27 GMT

Yes, I already did that in edit script and I am using this new variable.

Re: display sum as data point above grouped bar chart

tresB — Tue, 17 Jun 2014 09:16:41 GMT

With my screen shots, make the following changes:

Dimension1: Site

Dimension2: Date(MonthYear,'MMM-YY')

Second expression: =sum(TOTAL <Site> [Store Value])

Re: display sum as data point above grouped bar chart

Tue, 17 Jun 2014 09:21:18 GMT

Is the attached what you mean

Re: display sum as data point above grouped bar chart

Tue, 17 Jun 2014 09:27:12 GMT

Hmm...now its grouped in site and monthyear:

I'm using 'inv turnover' by the way:)

Re: display sum as data point above grouped bar chart

Tue, 17 Jun 2014 09:27:37 GMT

Hi, sorry I can't open the file. Thanks

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

Tue, 17 Jun 2014 09:34:41 GMT

Let me try again

Re: display sum as data point above grouped bar chart

Tue, 17 Jun 2014 10:08:01 GMT

Hi,

I think I have achieved it. Please check and if somewhere my understanding is wrong then let me know.

Thanks.

Re: display sum as data point above grouped bar chart

Wed, 18 Jun 2014 00:23:03 GMT

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.