Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
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?
Thank's!
Hi,
Thank you for you help , the following expression works:
aggr(if(isnull(NAME),'Other',NAME),NAME)
Try
=if(IsNUll(NAME) = -1, 'NA', NAME)
Thank you for your response... also this option doesnt work
Let's try something different:
What about Alt function?
Alt(NAME,'N/A') - this will replace every missing data with "N/A".
Are you sure that field is null? Maybe it is empty?
Try if(NAME='', 'N/A', NAME)
Thank you for your response,
I try as you suggest - it's replace everything to N/A except the null value
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:
Alt(num#(NAME),'N/A')
try
if(len(trim(YouField))=0,'N/A',YouField) as urField
Thank you for your response -
the len of null return null , so it doesn't work