Vertical Waterfall Diagram + total/delta line

[hempers055]

Hello,

is it possbile to create a vertical water fall diagram by using a bar chart object in QlikView?

The result should look like this:

It shows for each month the forecast value and on the last 3 lines the totals/delta

Thx 4 help

[QFabian]

Hi @hempers055 , you can do something like this :

using bar offset properties with column(x) function :

then, continue doing this for all of your columns, adding the offset like this :

total, with no offset , using column() function:

please try

[marcus_sommer]

The month + total is directly possible but the budget + delta could not simply be added as an extra expression. What you could do is to add total + delta + budget as dimension-values to the month field - just double the field within your data to get no conflict with any other views and then you query those values within your expression. Maybe with something like this:

if(MonthSpecial = 'total', sum(total value), if(MonthSpecial = 'budget', sum(budget), if(MonthSpecial = 'delta', sum(budget) - sum(total value), sum(value))))

- Marcus