Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
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?