Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
nakul1001
Contributor 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

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

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