Cumulative figures on a graph

Wed, 29 Jan 2014 21:39:08 GMT

Hi,

I really need someone help.

I have a data set that has a weight column and the weight cumulative column is calculated base on the direction .i.e. if the weigh was its added to cumulative ans if its out its removed from the cumulative.

I want to plot the cumulative weight on a chart, dependent on the dimension I use i.e. if I use the stockdate field, i want to see the last figure recorded for each date. If I use the stockmonthyear field, I want to use the last field for each stockmonthyearfield. I created the row column as I thought I could somehow get the max for each date and use that in set analysis somehow, but I cant get it working.

See snapshot of the data below, I have attached the full data set.

RowID	StockDate	StockMonthYear	Direction	Weight	WeightCum
1	04/12/2012	Dec 2012	In	1574.7	1574.7
2	04/12/2012	Dec 2012	Out	235	1339.7
3	05/12/2012	Dec 2012	In	115.9	1455.6
4	05/12/2012	Dec 2012	In	115.9	1571.5
5	05/12/2012	Dec 2012	In	97.2	1668.7

Any help would be much appreciated. Working example would be great.

Cheers

Simon

Re: Cumulative figures on a graph

maxgro — Wed, 29 Jan 2014 21:58:34 GMT

try with

Dimension = RowID

Expression = rangesum(Above(sum(Weight) * if(Direction='Out',-1,1), 0, RowNo()))

see attachment

Re: Cumulative figures on a graph

tabletuner — Wed, 29 Jan 2014 22:58:40 GMT

create 2 additional dimensions as is demonstrated in the example.

Cheers!

Re: Cumulative figures on a graph

Fri, 31 Jan 2014 10:18:28 GMT

Thank you, thats exactly what I wanted, much appreciated.

Cheers

Simon

topic Cumulative figures on a graph in QlikView

Cumulative figures on a graph

Re: Cumulative figures on a graph

Re: Cumulative figures on a graph

Re: Cumulative figures on a graph