Before function in QlikSense Pivot table

[gulshan_rohilla]

Hello everyone,

I want the below report in QlikSense

the upto total section is adding the current and before value in the column and I have achieved some part of it. I somehow managed to add the previous into current but the first value appears null and addition starts from second and also i am not able to convert the null values into zeroes. can anyone tell me how to do that. below is my attached screenshot

thanks in advance

[gulshan_rohilla]

My expression is

IF($(eSalesPartyWiseYTD)>0,($(eSalesPartyWiseYTD)+BEFORE($(eSalesPartyWiseYTD))),

IF(ISNULL(BEFORE($(eSalesPartyWiseYTD))) OR BEFORE($(eSalesPartyWiseYTD))='-',$(eSalesPartyWiseYTD))

[joe_nguyen]

Look into Rangesum function. I believe it would ignore nulls and sum up the numbers.

[gulshan_rohilla]

No it didn't work...