Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Replace null value with text

Hello everyone

I'm working in Qliksense with a table like this:

NullValues.PNG

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!

10 Replies
dwforest
Specialist II
Specialist II

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


Thiago Justen Teixeira Gonçalves
Farol BI
WhatsApp: 24 98152-1675
Skype: justen.thiago
Anonymous
Not applicable
Author

It doesn't work

Anonymous
Not applicable
Author

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

Anonymous
Not applicable
Author

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

ali_hijazi
Partner - Master II
Partner - Master II

you can use the below as an example

:

NullAsValue A,B;

Set NullValue = 'n/a';

LOAD A,B from ...

I can walk on water when it freezes
zebhashmi
Specialist
Specialist

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

Anonymous
Not applicable
Author

Doesn't work either

Thiago_Justen_

Could you please give us an example App?

Thiago Justen Teixeira Gonçalves
Farol BI
WhatsApp: 24 98152-1675
Skype: justen.thiago