Waterfall Chart begin with prior year

Anonymous — Tue, 31 Mar 2015 14:38:41 GMT

Hi All,

I've been able create a waterfall chart with the help of some posts here already, but now I'd like to kick it up a notch.

Here is my current info.

Dimension: %key_Location_Code

Expression: sum[Extended Revenue]

Bar Offset: if(RowNo()=1 or RowNo()= count(DISTINCT %key_Location_Code)+1 ,0,RangeSum(Above(sum([Extended Price]),1,RowNo()-1)))

I am trying to get the prior year's revenue as the first column, the current year as the last, and the change in revenue by location in between the two. I haven't been able to get the data all in the same chart.

I have attached a picture of two charts, side by side that I hope will help.

Thanks!

topic Waterfall Chart begin with prior year in QlikView

Waterfall Chart begin with prior year