Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
nickmarlborough
Creator
Creator

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
Partner - Creator III
Partner - 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.