NUll value

[smilingjohn]

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 

[marcus_sommer]

NULL is a special feature which only in databases/programming tools exists - empty/missing field-values in flat-files aren't NULL in this sense. To fetch them also as NULL you may apply something like this:

If(len(trim(Category)) = 0,'NULL',Category) as CAT

 - Marcus

[smilingjohn]

....

[marcus_sommer]

There are various possibilities how real NULL and the different other types of NOTHING could occur and if they cause issues (which is not always the case) might be resolved. The best explanation to the topic could you find here:

NULL handling in QlikView - Qlik Community - 1484472

 - Marcus