Qlik Community

Qlik Sense App Development

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

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
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

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