Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Chart accumulation with multiple dimensions

I'm having a problem with the accumulation feature in chart objects, specifically bar chart, while using multiple dimensions.  See attached .qvw.  How do we get an accumlated value on one dimension when the object has two dimensions?

I've tried rangesum() functions with a combo of aggr() and above() and below() to no avail.

I really appreciate any thoughts or direction.

Regards,

DB

2 Replies
Not applicable
Author

Hey David,

Please try this expression.

rangesum( above(total sum( Expression1),0,RowNo(total)))

Also check out the second tab 'Sheet 1' in attached file.

You wont get 242,480 in Bar char because you are looking at C with e and f in it.

So it will be 242480 + 169847 =  412327

If you want 242,480 then you should use Properties > Style > Grouped.

Thanks

AJ

Not applicable
Author

AJ,

Thank you very much for taking the time to look at this. You included some great ideas but I'm still wondering if there is any way possible to create a "Stacked" bar chart with the total values:

A - 26911

B - 109776

C - 242480

Just like this ......

2-28-2014 2-49-52 PM.png

Thanks again,

DB