Error in Cumulative Sum in Qliksense Table

[YashPatel0106]

Hi All,

I am facing some issue while calculating cumulative sum in Qliksense Table.

Following is the expression :

Sum(Aggr(RangeSum(Above(If(Column(5)='No'
,0,If(OrderDate=Date(BillDate,'DD-MM-YYYY'),Sum(OrderQty)-Sum(BilledQty),Sum(OrderQty))),0, RowNo())),DepotCode,MaterialNo,OrderDate,Key))

where Column(5) is the inscope column 

Expected Cumulative Remaining Qty

0

0

3

8

Please give your valuable feedback and Thanks in Advance.

Regards,

Yash P.

[YashPatel0106]

Order Date : 23-09-2019
Depot Code : 202
Material Code : 14053701020000

Other Ex 

Same order date and depot code
Material Code : 21182414001000 , 14053701005000

[YashPatel0106 · Accepted solution]

The issue got solved.

Used Sorting in AGGR.

(Aggr(RangeSum(Above( Sum(RemainingQty), 0, RowNo(TOTAL))),(DepotCode,TEXT,ASCENDING),(MaterialNo,TEXT,ASCENDING),(OrderDate,Numeric,ASCENDING),(Key,Text,ASCENDING)))

Thanks For Your Support.