Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Everyone.
I have answered my own question! I stumbled on an earlier forum entry here: http://community.qlik.com/forums/t/26209.aspx
Great
Richard,
What is the description for the earlier forum entry to which you referred? The link above appears to be broken.
Thanks,
Michael
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
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.
Thanks!
I will take a look at something similar.