Stop Qlik from loading rows with blank cell values

[Brysonds]

Hello,

I have a simple csv  file that contains the Category Parent, Category, Material

No matter what I try, Qlik is loading materials that have a blank category (these cells are empty in excel, and expressed as null in Qlik). I just want the record that have a category loaded.

I've tried the following, but no matter what I do these null records continue be created --- any suggestions?

1. filtered on category ='E1'

2. filtered on len(trim(category))>0

3. filtered on not(category)=''

4. filtered on isnull(category)=0

[Vegar · Accepted solution]

The len(trim(category))>0 should work it is pretty generic. What's the output of the field [TEST] when running the script  below?

Load [Category Parent], Category, Material,

len(trim(Category))>0 as [TEST]

FROM LIB://.../Simple.csv (txt...)

Where len(trim(Category))>0

[Brysonds]

Hey Vegar -- thank you for the quick reply. It seems the underlying issue was with a join. I needed to expand the filter to one more field due to another set of blanks, after applying len(trim(category))>0 and len(trim(material))>0, the results were correct. 

Thanks for your help!