Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
Showing results for 
Search instead for 
Did you mean: 
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)


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?


1 Reply

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