Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Join “Do More With Qlik” with Mike Tarallo to get a first-hand look at the New Authoring Experience, June 29th: REGISTER HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
jsf_fasoli
Creator II
Creator II

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
jsf_fasoli
Creator II
Creator II
Author

It doesn't work

jsf_fasoli
Creator II
Creator II
Author

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

bill_markham
Champion III
Champion III

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

ali_hijazi
Partner
Partner

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)

jsf_fasoli
Creator II
Creator II
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