Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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

Tags (3)
1 Solution

Accepted Solutions

Re: how to filter blank cell from the excel files

Load field

From file.xls (...)

Where len(field);

4 Replies

Re: how to filter blank cell from the excel files

Load field

From file.xls (...)

Where len(field);

Re: how to filter blank cell from the excel files

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

Re: how to filter blank cell from the excel files

Thanks for your help !

Not applicable

Re: how to filter blank cell from the excel files

It works now and thanks very much!!

Community Browser