Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
StevenWorm
New Contributor III

Remove Null Row

Hello qlikers,

My Table looks like:

Fruit          Comment
Apple        delicious
Banana     yellow
Grapes       -

- -> 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. 

Labels (2)
3 Replies
Highlighted
bharathadde
Contributor II

Re: Remove Null Row

Try this 

Dimension

=if(not isnull(Comment),Fruit) -- (Check box suppress the null value)

Expression

=Comment

MVP & Luminary
MVP & Luminary

Re: Remove Null Row

Try it with:

load ... from ... where len(trim(Comment));

- Marcus

sugathirajkumar
Contributor

Re: Remove Null Row

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)