How to replace 'zero' value field to 'N/A' in qlikview straight table.

[iahmadmca1]

Hi Team,

I have a straight table with zero value instead of zero value i Need 'N/A'. So could you please help me to do this.Please find the below example table for more details.

ID	Name	ZIP code	MObile
1	Surya	045642	9715879845
2	RAM	4578	0 instead of zero it should be(N/A)

Thanks,

Irshad Ahmad

[sunny_talwar]

May be like this

If(MObile= 0, 'N/A', MObile)

[aapurva09]

Hi,

Try this:

if(len(Mobile)<=0,'N/A', Mobile)

[iahmadmca1]

Thanks,Sunny

[ahaahaaha]

There is a suggestion to mark the answer Sunny as correct, thereby closing the topic 🙂

[iahmadmca1]

Hi sunny,

This expression is working fine but one issue is there when i am applying this logic the total count value is showing (--) please find the below expression.

=if(sum([Planned Downtime])=0,'N/A',[Planned Downtime])

i need only field value(N/A).if it is possible pleae reply back.

[sunny_talwar]

May be try this

If(Dimensionality() = 0, Sum([Planned Downtime]),

     If(sum([Planned Downtime])=0,'N/A',[Planned Downtime]))

[iahmadmca1]

Thanks Sunny;

It's working fine now we can close the topic.

[sunny_talwar]

Then close by marking the correct and helpful responses

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny