topic Re: Stop Qlik from loading rows with blank cell values in App Development

Stop Qlik from loading rows with blank cell values

Brysonds — Mon, 25 Apr 2022 18:28:53 GMT

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

Re: Stop Qlik from loading rows with blank cell values

Vegar — Mon, 25 Apr 2022 18:49:43 GMT

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

Re: Stop Qlik from loading rows with blank cell values

Brysonds — Mon, 25 Apr 2022 19:17:23 GMT

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!