Discussion board where members can learn more about Qlik Sense App Development and Usage.
I'm trying to suggest someone on how best to handle nulls.
In my experience, I have seen that not isnull() works fine but lately, I have seen it behaving weirdly.
So is it safe to say that len()>0 is a suitable replacement for not isnull() in where clauses?
Are there any exceptions/Caveats when with both approaches?
Go to Solution.
I often use
(or just without the >0 as condition, like If(Len(Trim(FIELD)), THEN ... , ELSE ...)
This also handles empty values / values containing only spaces, i.e. only return TRUE when there is 'something relevant'.
I like using Len(Trim(FieldName)) > 0
Both of you are correct.
I guess i'll award Stefan the correct answer since Sunny's been hogging all the points.