Text on stacked columns in a chart

[richard_chilvers]

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?

[richard_chilvers]

Everyone.

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

Great

[#3]

Richard,

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

Thanks,

Michael

[richard_chilvers]

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

[juraj_misina]

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.

[richard_chilvers]

Thanks!

I will take a look at something similar.