Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to filter blank cell from the excel files

Dear all,

I met a problem when uploaded data from excel files.

One of the fields has blank cells that contain nothing, and it should be filtered. But I've tried to use null or ' ' that none of them can succeed.

Could you please help me on this issue?

Many thanks and thanks in advance!!

Br,

Lisen

1 Solution

Accepted Solutions
MarcoWedel

Load field

From file.xls (...)

Where len(field);

View solution in original post

4 Replies
MarcoWedel

Load field

From file.xls (...)

Where len(field);

its_anandrjs

Hi,

There are many ways to do this or you can try

Load * from Source

Where Len(Field) > 0;

Or

You can create the Null flag and in front end use with expression to filter nulls

Ex:-

LOAD If(Len(ColB) = 0,1,0) as Flag,*;

LOAD * Inline [

ColA,ColB

a,34

b,3

c,

d,

e,34

];

sum({<Flag -= {1}>}ColB)

Regards

Anand

Not applicable
Author

Thanks for your help !

Not applicable
Author

It works now and thanks very much!!