Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
nickmarlborough
Contributor III
Contributor III

change the default value of null from ' - ' to ' N/A '

for values where there is simply no value, the default is '-' and that cannot be filtered on. 

Is there a way to make it default across the whole of Qlik so the value for anything without a value to be 'N/A'

Labels (2)
3 Replies
Clement15
Creator III
Creator III

Hello, I think this function could meet your expectations.

NullValue | Qlik Sense on Windows Help

qv_testing
Specialist II
Specialist II

use this

IF(TRIM(LEN(FieldName))=0, 'N/A', FieldName)

MayilVahanan

Hi

Try like below

NullAsValue | QlikView Help

 

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.