Qlik Sense Waterfall chart

[alan_grn]

Does anyone have an example of a Waterfall chart using Qlik Sense?

[petter · Accepted solution]

You can get a waterfall chart by using the stacked bar chart and having an offset for each step and make that offset a bar that has white as color so I won't show against the white background.

[Anonymous]

arthurfantaci/QlikSenseWaterfall · GitHub

[alan_grn]

Thanks. This is exactly what I was looking for.

[abhaysingh]

Hi Petter,

thanks for your feedback..

you write that exp in color ..

If(SubComponent='Offset',0,RGB(0,100+50*(Ord(Component)-65),0))

could you pls help me to make it understand..

and

you loaded that sample data..

data:

LOAD

  *

INLINE [

  Component, SubComponent, Value

    A, Offset, 0

    A, Value, 6

    B, Offset, 6

    B, Value, 3

    C, Offset, 9

    C, Value, 1

];

what if my data is like

load * inline

[     Process,     cost

     code, 10

     customization,20

     design,30

marketing,15

sales,     25];

than how i can make my water fall chart?

[petter]

You have to calculate the offset yourself - for instance in the load script like this:

load

  Process,

  cost,

  RangeSum(Peek('Offset'),0) + RangeSum(Peek('cost'),0) AS Offset

inline

[     Process,     cost

     code, 10

     customization,20

     design,30

marketing,15

sales,     25];

It could also be calculated on the fly in the chart by making a calculated value based on:

Above('Offset') + Above('cost') and label (name) the expression as Offset