Missing Null Before Values in Pivot Qlik Sense

[Kailash_Shaw]

Hello Everyone!

I have this strange issue. Please refer to the screenshot.

I am trying to get the 'Total' values appear in next Date columns using before, but it is appearing Null for few.

Kindly suggest.

[Mario_De_Felipe]

Hi @Kailash_Shaw ,

I'm not sure about your expression, but it seems a problem when you are doing a SUM with the plus operator instead of using RangeSum() function. The plus operator doesn't support Null values: add a number to Null always results Null. With RangeSum() function you can avoid this problem, typically you would make an expression RangeSum(SUM(Sales), before(SUM(Sales)).

Hope it helps

[Kailash_Shaw]

Thanks @Mario_De_Felipe 

I have found this issue generic in Sense. Nulls are missing values for dimension combinations. I will have to replace the missing values with 0 using script. So I am trying to work out a script.