Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Order Date : 23-09-2019
Depot Code : 202
Material Code : 14053701020000
Other Ex
Same order date and depot code
Material Code : 21182414001000 , 14053701005000
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.