topic Text on stacked columns in a chart in QlikView

Text on stacked columns in a chart

richard_chilvers — Wed, 08 Dec 2010 11:38:49 GMT

My chart shows the stacked values of A and B by month.

I would like to show text giving the value of B as a percentage of A. I can calculate this as a 3rd experssion.

Previously, I could tick "Values on Data Point" for this 3rd expression (only) and the percentage would display.

However, suddenly (and maybe since I upgraded to vn9 SR6 ?) the value displayed is simply the total of all expressions, not matter for which expression I tick the box.

Any ideas why this might be or how I acheiev what I want?

Text on stacked columns in a chart

richard_chilvers — Wed, 08 Dec 2010 12:03:31 GMT

Everyone.

I have answered my own question! I stumbled on an earlier forum entry here: http://community.qlik.com/forums/t/26209.aspx

Great

Text on stacked columns in a chart

Fri, 20 May 2011 19:44:28 GMT

Richard,

What is the description for the earlier forum entry to which you referred? The link above appears to be broken.

Thanks,

Michael

Text on stacked columns in a chart

richard_chilvers — Thu, 23 Jun 2011 15:12:23 GMT

Hi Michael

Sorry for the slow response. I need to find the forum entry for you, but will revery shortly, or give you a more detailed answer.

Regards

Re: Text on stacked columns in a chart

juraj_misina — Mon, 01 Jul 2013 09:32:11 GMT

Hi,

I just came across this post when trying to achieve the same. I have a stacked bar chart with summary of activities per month, summing up duration of activities within a month. I have two dimensions (MonthYear, Activity) and one expression (sum(duration)). What worked for me was add second expression with TOTAL modifier to leave out Activity dimension, like this:

sum(TOTAL<MonthYear> Duration)

This is not displayed as bar, but only as value on datapoint.

Re: Text on stacked columns in a chart

richard_chilvers — Mon, 01 Jul 2013 15:49:40 GMT

Thanks!

I will take a look at something similar.