Qlik Community

Qlik Design Blog

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

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
Employee
Employee

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

14 Comments
Partner
Partner

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

Can we please have this in ALL Sense charts?

0 Likes
2,224 Views
Master
Master

Thanks a lot, cool stuff

0 Likes
2,224 Views
Contributor II
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!

2,224 Views
Contributor
Contributor

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

2,224 Views
Contributor II
Contributor II

HI Carlos Monroy,

Its very helpful  and Thanks a lot.

Regards,

Gopal k

0 Likes
2,224 Views
Contributor
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?

2,224 Views