How to sum rows above last transaction!?

Thu, 08 Aug 2013 09:48:27 GMT

Hi i am quiet new to QW and i hope some one can help with my problem.

I wanna make a bar chart containing bars over ages and value of the stock, but i only wanna show stock until Qty <= ENTEREDQTY

ex. Date 31-07-2013. QTY is lower then ENTEREDQTY here i whant to date returned in a new colum - DateFlag

Date 31-08-2012 QTY 1+23 = 24 here i what the same.
somehow sum rows above to compare with value in stock?

I wanna do this in the scrip because i dont need the data if

ITEMNUMBER	ITEMGROUP	=Date(DATE)	sum(QTY)	sum(ENTEREDQTY)	sum(VALUE)	Stockvalue
RESJLG1120515	17JLG	31-10-2007	2	24	13	0
RESJLG1120515	17JLG	31-01-2008	6	24	43	0
RESJLG1120515	17JLG	29-02-2008	23	24	162	0
RESJLG1120515	17JLG	31-03-2008	20	24	123	0
RESJLG1120515	17JLG	31-08-2008	2	24	12	0
RESJLG1120515	17JLG	31-10-2008	7	24	45	0
RESJLG1120515	17JLG	31-03-2009	6	24	39	0
RESJLG1120515	17JLG	30-04-2009	5	24	33	0
RESJLG1120515	17JLG	31-10-2011	6	24	39	0
RESJLG1120515	17JLG	31-08-2012	1	24	7	7
RESJLG1120515	17JLG	31-07-2013	23	24	150	150

Thanks!

Re: How to sum rows above last transaction!?

Thu, 08 Aug 2013 11:22:51 GMT

right now i use

if( sum(ENTEREDQTY) >= rangesum (below(sum(QTY),0,sum(Total QTY))), Sum(VALUE))

this work in a table chart but now in bar chart, if the first value in QTY is below ENTEREDQTY, If there is a rest i want the rest from next transaction

topic Re: How to sum rows above last transaction!? in QlikView

How to sum rows above last transaction!?

Re: How to sum rows above last transaction!?