Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Cumulative figures on a graph

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.

RowIDStockDateStockMonthYearDirectionWeightWeightCum
104/12/2012Dec 2012In1574.71574.7
204/12/2012Dec 2012Out2351339.7
305/12/2012Dec 2012In115.91455.6
405/12/2012Dec 2012In115.91571.5
505/12/2012Dec 2012In97.21668.7

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

Cheers

Simon

1 Solution

Accepted Solutions
tabletuner
Creator III
Creator III

create 2 additional dimensions as is demonstrated in the example.

Cheers!

View solution in original post

3 Replies
maxgro
MVP
MVP

try with

Dimension = RowID

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

see attachment

tabletuner
Creator III
Creator III

create 2 additional dimensions as is demonstrated in the example.

Cheers!

Not applicable
Author

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

Cheers

Simon