Discussion board where members can get started with Qlik Sense.
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.
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
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.
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
Could you please give us an example App?