Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
LINKEDIN LIVE: Democratizing data to enhance customer-centricity. JULY 29TH REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
iahmadmca1
Contributor III
Contributor III

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

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.

IDNameZIP codeMObile

1

  Surya0456429715879845
2  RAM45780 instead of zero it should be(N/A)

Thanks,

Irshad Ahmad

8 Replies
sunny_talwar

May be like this

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

aapurva09
Creator
Creator

Hi,

Try this:

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

iahmadmca1
Contributor III
Contributor III
Author

Thanks,Sunny

ahaahaaha
Master
Master

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

iahmadmca1
Contributor III
Contributor III
Author

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
Contributor III
Contributor III
Author

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