I create a table in qliksense,
I want to replace the value null to 'N/A' in each field.
I used in the following expression , but it doesn't replace to the value , and stay null:
=if(IsNUll(NAME), 'NA', NAME)
Could you please advice?
Solved! Go to Solution.
Let's try something different:
What about Alt function?
Alt(NAME,'N/A') - this will replace every missing data with "N/A".
Thank you for your response,
I try it but it didn't work ...
if i write = if(NAME='', 'N/A') , only the null value stay but in the display it didn't show the 'N/A' value....
Sorry, just a one mistake - this function check for a valid number representation.
So, do this: