topic Re: Waterfall Chart in Qlikview in QlikView

Waterfall Chart in Qlikview

GauravSS04 — Tue, 22 Jan 2019 11:20:26 GMT

In this example, first bar shows the total headcount and rest of them are like leavers, late entry, others, transfer out which I would like to show the bar's reducing as employee count reduces from previous month (refer first bar). However, when it comes to Joiners the bar should move up and after the other addition or subtraction (eg. Joiners, Leavers, conversion etc) it should be in the level of Actual headcount.

I used simple expression in Bar Offset as Sum([HC Previous Month])-Sum([Leavers])-Sum([Late Entry OUT]) and so on. Also for joiners I tried adding/subtracting them but still don't get the accurate chart.

Re: Waterfall Chart in Qlikview

Jacek — Tue, 22 Jan 2019 12:32:11 GMT

Please provide sample data

Re: Waterfall Chart in Qlikview

rubenmarin — Tue, 22 Jan 2019 15:43:40 GMT

Hi, from your post I suppose that you are using an expression for each of the basrs. In this case note that the offset for [Late Entry Leavers] and [Joiners] should be the same. (one is supposed to substract from total and the other adds, but both bars should start at bottom of [Late Entry Leavers] because positive bars are painted from botttom to top.

[Late Entry Joiners] should add [Joiners] instead of substract them: Sum([HC Previous Month])-Sum([Leavers])-Sum([Late Entry OUT])+Sum([Joiners])

Re: Waterfall Chart in Qlikview

GauravSS04 — Wed, 23 Jan 2019 05:44:06 GMT

Thanks a lot for your help...