Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to calculate and show a sub total in a Water fall chart?

Hi QlikView gurus,

I have created a waterfall bar chat that shows Indirect and Direct costs.

Here I want to show individual indirect cost bars , a subtotal for indirect costs,  a bar for direct cost and finally followed by the grand total bar.

(Please see the attached image for more clarity)

cost_waterfall_subtotal.PNG

To get the total I am using this expression  " =RangeSum(Above(Column(2)), Above(Column(1)) ) "

However, I am not able to get the sub total ('Total Indirect Costs') If I do, it gets double counted.

Any ideas/thoughts?

Thanks

1 Reply
sunny_talwar

Would you be able to share a sample where you have been trying it out?