Qlik Community

Qlik Design Blog

All about product and Qlik solutions: scripting, data modeling, visual design, extensions, best practices, etc.

Employee
Employee

The new Waterfall chart

One of our new additions to the charts library is the Waterfall chart. It’s useful to visualize how an initial value evolves (increment or decrements) over time or in distinct stages. It’s widely used across companies and finance analysis seems to be a good fit for the waterfall chart. We commonly see this type of chart for Income or Cash flow statements.

0.png

How it works?

Qlik Sense waterfall chart is a simple non-dimensional chart, it’s composed by expressions only. Each measure can be configured to “Add”, “Subtract”, or “Subtotal”. Meaning we have total control over the graphical representation of the values, we could tell a positive number to subtract its value from previous column and viceversa.

The Income Statement example

The CFO of the company Fitness Equipment Limited (from Wikipedia) wants to visualize and analyze its company income statement by year.

1.png

After getting the data into Qlik Sense (one table with three columns, Concept, Year, and Amount) it's time to represent the Income Statements table above with a Waterfall chart. Remember, the goal is to show the profit (or loss) for the year amount, but more importantly how was the flow to get to that amount.

Creating the chart

  • In edit mode, drag and drop the new Waterfall chart into the Qlik Sense app
  • Add the first measure, it will typically be the starting amount or opening value. Revenue will make it in our example.
    Sum({<Concept={'Revenue'}>}Amount)
  • Add as many measures as you need to complete the individual contributing amounts. In our example:
    • Cost of Sales
    • SGA expenses
    • Gains from disposal of FA
    • Interest expense
    • Income tax expense

Subtotals

For those balance measures and those amounts that denote subtotals such as Gross Profit or Operating profit we don't need to create an expression, we just need to check the subtotal checkbox in the preceding measure.

For example, to calculate Gross Profit (Revenue - Cost of Sales) check "Subtotals" check box in Cost of Sales measure and set the "Subtotal label" to Gross Profit. Perform the same operation for all of the balance points in the chart.

Spicing it up

Waterfall chart comes with the usual customization panels as seen in any other Qlik Sense chart, but this time we have a dedicated Color section that includes a color picker for each one of the bar types that inhabit your chart.

The final waterfall chart looks like the picture below. It includes a year list box so now the CFO and any user will be able to quickly  visualize different years of Income Statements to analyze how each piece contributes to the total profit.

3.png

This is just an example of what a Waterfall chart can do for your business but I'm sure there are many more use cases for it, please share your experience with Waterfall chart in the comment section below.

Enjoy it!

Arturo

PS: Find attached the Qlik Sense with the examples shown in the blog post

11 Comments
anderseriksson
Contributor III

> this time we have a dedicated Color section that includes a color picker

Can we please have this in ALL Sense charts?

0 Likes
3 Views
beck110979
Valued Contributor III

Thanks a lot, cool stuff

0 Likes
3 Views
bbainsslalom
New Contributor II

Are there plans to enhance this chart to support one or two dimensions?. Say I want to use this chart type to see how my company's brands contributed to the difference between our sales forecast and actuals. I don't see how I can do this with the  current Waterfall chart object. If I'm missing a technique that will let the object meet this use case, please let me know. Thanks!

3 Views
nandohoffmann
New Contributor

+1 would be really appreciated if there is an easy way to implement. Would be happy if anyone could help!

0 Likes
3 Views
gopalsvk37
New Contributor II

HI Carlos Monroy,

Its very helpful  and Thanks a lot.

Regards,

Gopal k

0 Likes
3 Views
nandohoffmann
New Contributor

Any update on BuddyBains question? I want to show the sales evolution from one year to the other and the impact of for example the top 10 products, countries etc and the rest in category others. This must be essential for a lot of corporations!


Is there an easy way to do this? When could we expect this feature to be added?

0 Likes
3 Views
Employee
Employee

Hi Nando - thanks for raising this again - let me check with plu‌ and czo‌ - they may know.

Patrik / Caique - thoughts?

"Are there plans to enhance this chart to support one or two dimensions?. Say I want to use this chart type to see how my company's brands contributed to the difference between our sales forecast and actuals. I don't see how I can do this with the  current Waterfall chart object. If I'm missing a technique that will let the object meet this use case, please let me know. Thanks!"


Regards,

Mike T

0 Likes
3 Views
Employee
Employee

Hi Michael,

We hope to make improvements to the Waterfall chart in that direction but other development has taken precedence so far. Right now the waterfall chart supports measures which can include set analysis expressions.

Thanks,

Patric

0 Likes
3 Views
nandohoffmann
New Contributor

Hi Michael,

Thanks for the reply. It is a pitty because at least in our company people love waterfalls and displaying them by different dimension could be a key differentiating factor and  a feature that would drive conversion and getting people off excel - I hope you could consider to prioritize this in the future.

Regards,

Nando

0 Likes
3 Views
Employee
Employee

Yes, agree, thanks for the feedback.

0 Likes
3 Views
ccaporaso
New Contributor III

https://community.qlik.com/blogs/qlikviewdesignblog/2017/11/03/new-waterfall-chart?et=blogs.comment.created#comment-68727

Cecilia Caporaso

Socia

Teléfono: (5411) 4702-1791

Celular: (54911) 5567-8783

2018-08-09 5:12 GMT-03:00 Patric Nordström <qcwebmaster@qlikview.com>:

0 Likes
3 Views