topic considering null values in script in QlikView

considering null values in script

smilingjohn — Thu, 05 May 2022 09:37:10 GMT

Hi All,

I have a field called Category which has many null values as shown in the screenshot below .

I am trying to consider null values in the script like this

If(Isnull( Category),'NULL',Category) as CAT, but this is not renaming the null values , it remains the same

Can you please help me in handling this ?

Thanks in Advance

vchuprina — Thu, 05 May 2022 08:31:20 GMT

Hi,

Looks like null and (null) are not nulls it’s a text, so probably your expression should be

IF(Wildmatch(Category, '*null*') or IsNull(Category), 'NULL', Category) AS Category

Also if you have empty rows you can add third condition

IF(Wildmatch(Category, '*null*') or IsNull(Category) or trim(len(Category))=0, 'NULL', Category) AS Category

Regards,

Vitalii