Discussion board for questions on how to use Qlik Community and its features.
I am looking to mark all Null in only one field as a value. I added the NullasValue to my script but it marked all Null as a value. I am only looking to mark only one field Nulls as a value.
Go to Solution.
you can try like
then it will mark null as value only in this field,
if you use
nullasvalue * mean all fiels,
only in these two fields...
see in the help file...
You can deal as below
IF(IsNull(YourFieldName) or len(trim(YourFieldName))=0,'Unknown', YourFieldName) as YourFieldName
Try an if statement:
if(len(trim(fieldC))=0, 'MyValue', fieldC) as fieldC
You can check the following video post on my blog:
I hope this helps!
Thank you very much, this was the answer i was looking for. I did have * and did not put two and two together. Great job! Thank you again.