Discussion board where members can get started with Qlik Sense.
My Table looks like:
Fruit CommentApple deliciousBanana yellowGrapes -
- -> is Null, but i dont want the row with the grapes in my table.
So I'm creating a new table with a where clause. But I cant find something similar like SQL statement Where Comment is Null. How can I "delete/remove" the row with the null?
Thank you in advance.
=if(not isnull(Comment),Fruit) -- (Check box suppress the null value)
Try it with:
load ... from ... where len(trim(Comment));
Dim 1 :- =if(Comment<>'-',AddFruit)
Dim 2 : Comment
Suppress null value
if you dont want to suppress null value then
Dime 1:- =if(Comment<>'-',AddFruit)
Dim 2 :- =if(Comment<>'-',Comment)