aggr function with first sorted value

Tue, 23 Dec 2014 12:06:03 GMT

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

topic aggr function with first sorted value in QlikView

aggr function with first sorted value