Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
richard_chilvers
Specialist
Specialist

Text on stacked columns in a chart

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?

5 Replies
richard_chilvers
Specialist
Specialist
Author

Everyone.

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

Great Smile

Not applicable

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
Specialist
Specialist
Author

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
Luminary Alumni
Luminary Alumni

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
Specialist
Specialist
Author

Thanks!

I will take a look at something similar.