topic Re: Replace Null, - Value to Zero in Qlik Sense Pivot Table in App Development

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

sona_sa — Mon, 20 Dec 2021 21:08:46 GMT

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,

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

agigliotti — Fri, 22 May 2020 07:24:19 GMT

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

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

sona_sa — Fri, 22 May 2020 07:35:15 GMT

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,

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

agigliotti — Fri, 22 May 2020 08:02:25 GMT

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.

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

Saravanan_Desingh — Sun, 14 Jun 2020 17:43:14 GMT

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

RangeSum(FieldA,0) As FieldA