Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)))
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)))