Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

cancel
Showing results for 
Search instead for 
Did you mean: 
Taylorcc
Contributor III
Contributor III

Replace 0 with N/A in chart

Hello, 

I have created the measure - sum(if (([Principal Focus]='Clinical Care'), [Episode Target]))

Is it possible for the answer to display 'N/A' if the calculation returns 0, rather than the 0? 

Thank you!

Labels (3)
1 Solution

Accepted Solutions
Ivan_Bozov
Luminary
Luminary

Hi, try this:

IF(SUM({<[Principal Focus]={'Clinical Care'}>}[Episode Target])>0, SUM({<[Principal Focus]={'Clinical Care'}>}[Episode Target]), 'N/A')

 

View solution in original post

2 Replies
Ivan_Bozov
Luminary
Luminary

Hi, try this:

IF(SUM({<[Principal Focus]={'Clinical Care'}>}[Episode Target])>0, SUM({<[Principal Focus]={'Clinical Care'}>}[Episode Target]), 'N/A')

 

View solution in original post

Taylorcc
Contributor III
Contributor III
Author

This works perfectly! Thank you