Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

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

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

Labels (1)
4 Replies
Highlighted
Partner
Partner

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

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

Highlighted
Creator
Creator

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

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

Highlighted
Partner
Partner

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

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.

Highlighted
Specialist III
Specialist III

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

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

RangeSum(FieldA,0) As FieldA