Replace null value with text

[Anonymous]

Hello everyone

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.

Any thoughts?

Thanks!

[dwforest]

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.

[Thiago_Justen_]

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" )

[Anonymous]

It doesn't work

[Anonymous]

It would be preferrable if it could be done on the front-end

[Anonymous]

Whilst you may prefer a front solution, the way to go is a back end script solution.

[ali_hijazi]

you can use the below as an example

:

NullAsValue A,B;

Set NullValue = 'n/a';

LOAD A,B from ...

[zebhashmi]

If(len(trim(Client Type))= 0, 'Person', Client Type)

[Anonymous]

Doesn't work either

[Thiago_Justen_]

Could you please give us an example App?