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 with Zero

Hi,

I have tried to replace null value to zero. But unsuccessful. You can find out the expression - I used all possible function / technique.

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

Regards,

AK

Labels (1)
2 Replies
Highlighted
Partner
Partner

Re: Replace Null Value with Zero

Hello,

add in the script, in the load instruction

if (isnull(FieldName)),0,FieldName) as FieldName,

 

Highlighted
Specialist III
Specialist III

Re: Replace Null Value with Zero

Try this.

RangeSum(FieldName,0) As FieldName