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: 
nakul1001
Creator II
Creator II

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?