Showing Totals on Bar Charts

[#1]

I have created a Bar chart using Months as a dimension with a cost of sales as my expression (as per below):

These are the 12 x months accross the year .. but how do I show a Year Total to the far right of this chart?

I was hoping for some kind of 'Show Total' tick box option but cannot see one?

Anyone have any ideas?

Thanks

[swuehl]

Are you using QV11? And are you using only one dimension and several expressions in a stacked bar style?

In QV11 there is a total option now on dimension limits tab, and it seems to work fine with grouped bars, but when I select stacked style, the total bar seems not to be displayed right (I needed to set static max to show it correct).

[vijay_iitkgp]

Go to Chart Properties ----> Presentation and check the show total ( label)

VIjay

[#4]

Hi Vijay

Thanks for you response.

I have already checked the show total (label) box and ensured this is ticked.  I thought this would be the answer but unfortunately makes no difference.

Any other suggestions?

Bri.

[#5]

Hi

Thanks for your reply, unfortunately I am using QV10.

I am using 2 dimensions (month and category) to produce the stacked split and one expression (the cost of sales).

Any other ideas?

[swuehl]

It seems that QV doesn't like the two dimensions together with the total (played around a bit, the only way I got a total bar is that I created a total with one dimension, then having the option checked and total bar shown, I added second dimension. Ended up with a total bar of correct size, but not stacked by second dimension / multicolored).

Maybe you could apply adding a total value to your first dimension like discussed e.g. here:

http://community.qlik.com/message/92253

Regards,

Stefan

[#7]

Thanks Stefan, I will do some playing around .. cheers for hte example!

Bri.