Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be like this
If(MObile= 0, 'N/A', MObile)
Hi,
Try this:
if(len(Mobile)<=0,'N/A', Mobile)
Thanks,Sunny
There is a suggestion to mark the answer Sunny as correct, thereby closing the topic 🙂
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.
May be try this
If(Dimensionality() = 0, Sum([Planned Downtime]),
If(sum([Planned Downtime])=0,'N/A',[Planned Downtime]))
Thanks Sunny;
It's working fine now we can close the topic.
Then close by marking the correct and helpful responses
Qlik Community Tip: Marking Replies as Correct or Helpful
Best,
Sunny