
Creator
2024-03-13
05:11 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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'
3 Replies

Partner - Specialist
2024-03-13
05:13 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello, I think this function could meet your expectations.
526 Views

Specialist II
2024-03-13
05:19 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
use this
IF(TRIM(LEN(FieldName))=0, 'N/A', FieldName)
522 Views

MVP
2024-03-13
05:19 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi
Try like below
Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Please close the thread by marking correct answer & give likes if you like the post.
