Dear Qlik Community,
My data looks similar to the below:
Division | From Status | To Status | Date Stamp | Amount |
---|
A | | New | 01/01/2014 | 100000 |
A | New | Status A | 10/01/2014 | 100000 |
A | Status A | Dead | 05/02/2014 | 100000 |
B | New | Status A | 05/01/2014 | 25000 |
B | Status A | Status B | 06/01/2014 | 25000 |
B | Status B | Status C | 20/02/2014 | 25000 |
B | Status C | Trade | 25/02/2014 | 25000 |
C | | New | 08/02/2014 | 300000 |
C | Status A | Status B | 25/02/2014 | 300000 |
C | Status B | Trade | 04/04/2014 | 300000 |
I want to set up a pipeline waterfall graph that between two dates (using variables) shows the movement between the two dates.
For example if February dates were selected, the waterfall graph would show start of the month amount of 125000 (division A & B), removal of 25000 (division B) due to now trading, Addition of 300000 (division C) as it is a new division, removal of 100000 (division A) as it is now "Dead" and a closing month amount of 300000 (division C) as the only remaining "pipeline" division
I need to understand what dimensions and expressions need to be added.
Many thanks
Drew