Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
alan_grn
Creator II
Creator II

Qlik Sense Waterfall chart

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

1 Solution

Accepted Solutions
petter
Partner - Champion III
Partner - Champion III

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.

2015-04-10 #2.PNG

View solution in original post

5 Replies
petter
Partner - Champion III
Partner - Champion III

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.

2015-04-10 #2.PNG

Anonymous
Not applicable

alan_grn
Creator II
Creator II
Author

Thanks. This is exactly what I was looking for.

abhaysingh
Specialist II
Specialist II

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
Partner - Champion III
Partner - Champion III

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