Full accumulation

[smilingjohn]

Hi All,

I was using this below expression in qlikview and selected the option of full accumulation .which works perfectly

=if(Count(Expense)>0,
Count(Distinct if(SubGroup=SubDoor and Floor(Date)=Floor(ClosedDate),SalesID)),
Count(if(Floor(Date)=Floor(ClosedDate),SalesID)))

But i want to use range sum in the same expression how do i do it ? and uncheck full accumulation option . 

But in Qliksense there is no option of Full Acumulation how can use RangeSum for the above expression .

Need to change the above expression to range sum  :

Can any one please help on this 

Thanks in advance

[sunny_talwar · Accepted solution]

May be this

RangeSum(Above(TOTAL
If(Count(Expense) > 0,
Count(Distinct If(SubGroup = SubDoor and Floor(Date) = Floor(ClosedDate), SalesID)),
Count(If(Floor(Date) = Floor(ClosedDate), SalesID)))
, 0, RowNo(TOTAL)))