Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
....
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