Replacing Null Values with Unknown

[Beginner]

Hi,

I have a field with some of the data being null values (blank). I would like to show those blank cells as 'Unknown'. 

Right now my measure is Count([Status])

Should it look something like this in my measure?

Count ([Status]) & if(isnull([Status]), 'Unknown' [Status])

It is showing an error for me: ')' expected

[OmarBenSalem]

In the script, change ur field as follow:

if(len(trim(Status))=0,'Unknown',Status) as Status

[OmarBenSalem]

If u don't want to alter ur script (which is the best approach)

You can try the NullCount funtion

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/CounterAggrega...

[Beginner]

Is there a way besides altering the script? Can I add an expression to my measure/dimension?

[Beginner · Accepted solution]

Nevermind, I just used the Replace feature in Data Manager to replace all Null values with Unknown