Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

gulshan_rohilla
New Contributor

Before function in QlikSense Pivot table

Hello everyone,

I want the below report in QlikSense

query.PNG

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

q1.PNG

q2.PNG

thanks in advance

Tags (1)
3 Replies
gulshan_rohilla
New Contributor

Re: Before function in QlikSense Pivot table

My expression is

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

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

joe_nguyen
New Contributor II

Re: Before function in QlikSense Pivot table

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

gulshan_rohilla
New Contributor

Re: Before function in QlikSense Pivot table

No it didn't work...