Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Replace null value with text

Hello everyone

I'm working in Qliksense with a table like this:

NullValues.PNG

For some plan types there is no value for client type. I need those records to be considered as Person.

I've tried if (isNull("Client Type"), 'Person', "Client Type") but nothing has changed.

Any thoughts?

Thanks!

10 Replies
Anonymous
Not applicable
Author

I would really love to, but is an app from a client and is pretty big to mask the data. Sorry!

Thanks for trying to help me