Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Field Values - or Null or 0 Replacement

Hi Experts,

I want to replace a field values like - , Null or 0 by 1. which function should i use to replace Null or 0 value by 1 ?

Thanks & Regards,

2 Replies
MVP
MVP

Re: Field Values - or Null or 0 Replacement

May be like this

If(Field = 0 or IsNull(Field) or Len(Trim(Field)) = 0, 1, Field) as Field

rupamjyotidas
Valued Contributor

Re: Field Values - or Null or 0 Replacement

If(Match(Field,0,'-')>0 or IsNull(Field) or Len(Trim(Field)) <1, 1, FieldName) as FieldName