topic Missing Null Before Values in Pivot Qlik Sense in App Development

Missing Null Before Values in Pivot Qlik Sense

Kailash_Shaw — Mon, 17 Oct 2022 07:48:04 GMT

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.

Re: Missing Null Before Values in Pivot Qlik Sense

Mario_De_Felipe — Tue, 25 Oct 2022 07:14:07 GMT

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

Re: Missing Null Before Values in Pivot Qlik Sense

Kailash_Shaw — Tue, 25 Oct 2022 08:38:51 GMT

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.