Skip to main content

App Development

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

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Brysonds
Contributor II
Contributor II

Stop Qlik from loading rows with blank cell values

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

 

Labels (1)
1 Solution

Accepted Solutions
Vegar
MVP
MVP

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

View solution in original post

2 Replies
Vegar
MVP
MVP

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
Contributor II
Contributor II
Author

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!