Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Giselle100
Contributor III
Contributor III

Remove entire row with null value

Hi

 

Let say I have dimensions

name, surname and ID no.

If ID No field is null then delete entire row.

How do I load this in the script in Qliksense?

 

Labels (2)
1 Reply
nazaQ
Partner - Contributor III
Partner - Contributor III

Hi,
using the clause: Where not isnull(ID)
in your statement can you solve the problem?