QlikView for Developers Cookbook

Creating a waterfall chart

A waterfall chart is a type of bar chart used to show a whole value and the breakdown of that value into other subvalues, all in one chart. We can implement it in QlikView using the Bar Offset option.

In this example, we are going to demonstrate the chart showing a profit and loss breakdown.

Getting ready

Load the following script:

LOAD * INLINE [
    Category, Value
    Sales, 62000
    COGS, 25000
    Expenses, 27000
    Tax, 3000
];

How to do it…

The following steps show you how to create a waterfall chart:

1. Create a new bar chart. There is no dimension in this chart. We need to add three expressions:

   Sales $	Sum({<Category={'Sales'}>} Value)
   COGS $	Sum({<Category={'COGS'}>} Value)
   Expenses $	Sum({<Category={'Expenses'}>} Value) ...