Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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