I'm working in Qliksense with a table like this:
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.
Usually works best if you can resolve the null values during data load if possible; not a direct solution but may be a viable workaround for some.
It would be preferrable if it could be done on the front-end
Whilst you may prefer a front solution, the way to go is a back end script solution.
As David said, should better resolve it into load script. But you may try something like this:
If(len(trim("Client Type"))= 0 or "Client Type"='NULL' or "Client Type"='-', 'Person', "Client Type" )
It doesn't work
Could you please give us an example App?
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
you can use the below as an example
Set NullValue = 'n/a';
LOAD A,B from ...
If(len(trim(Client Type))= 0, 'Person', Client Type)
Doesn't work either
Retrieving data ...