Replace Null, - Value to Zero in Qlik Sense Pivot Table

[sona_sa]

Hi,

I have tried to replace null value, missing value or - to zero (0). But unsuccessful. You can find out the in expression - I used all possible function / technique.

I am attaching the qvf, If anyone can help me on this, Please help.

Thanks in advance.

Regards,

AK

[agigliotti]

Hi,
You can't replace null with 0 because you don't have data for those combinations of dimensions values (ex. Intransit receipt - 2020).

[sona_sa]

Hi Friends,

Thanks for reply. This is for limited row (Only for 50 Data - Debugged QVF). Like that there is lots of dimension value. Is there no any way to maintain it. I have tried but not able to get this zero output.

By Script / By Expression change / using of Set Analysis

Please suggest.

Regards,

AK

[agigliotti]

When you don't have data you get null.
The only way to get zero is having rows data with 0 as value of measure ([Quantity Rate]).
I hope now is clearer.

[Saravanan_Desingh]

I can't see your code. But try this.

RangeSum(FieldA,0) As FieldA