Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

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

Remove Nulls and /or blank values

I have a table where I want to remove Null and/or blank values in the script. I've used not IsNull(), field <> '' and len(trim(field))>0 and nothing works. I even checked the data in the table (see screenshot) and it appears to be null. I unchecked show null values in the table and they disappear. Does anyone know why the records would still appear?

 

Thank you,

EdNull.JPG

1 Reply
Partner
Partner

Re: Remove Nulls and /or blank values

Hi, do you have a sample QVF you could share?