Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
skh
Contributor

Exclude blank cells in data

Hi,

What is the syntax to exclude null values in my data?  The field is called DFLOW?

Thanks,

Sunil

Tags (1)
1 Solution

Accepted Solutions

Re: Exclude blank cells in data

Hi,

Elaborating on my example above

Table:
LOAD *,
FROM File.qvd (qvd)

WHERE Len(Field); // greater than zero means true, so load all where Field is not null

You can use any other SQL function, but it will depend on your ODBC driver and your database manager.

Hope that helps.

Miguel

View solution in original post

7 Replies
skh
Contributor

Exclude blank cells in data

This is in my load script by the way.

Thanks,

Sunil

Re: Exclude blank cells in data

Hi Sunil,

I prefer to use

Table:

LOAD *,

     If(Len(Field) = 0, 'Null', Field) AS Field

... // source here

Hope that helps.

Miguel

skh
Contributor

Re: Exclude blank cells in data

Hi Miguel,

Thanks but I want to exlude the blank values and not specify them as a field.

Something like:

Where DFLOW <> ‘ ‘ .

Highlighted
Luminary
Luminary

Exclude blank cells in data

The you should do right that. Use a where close after the Load statement.

skh
Contributor

Exclude blank cells in data

Thanks but i need to know the exact syntax to write?

Luminary
Luminary

Exclude blank cells in data

Load * from youtfile.qvd (qvd)

Where DFLOW <> ' ';

Re: Exclude blank cells in data

Hi,

Elaborating on my example above

Table:
LOAD *,
FROM File.qvd (qvd)

WHERE Len(Field); // greater than zero means true, so load all where Field is not null

You can use any other SQL function, but it will depend on your ODBC driver and your database manager.

Hope that helps.

Miguel

View solution in original post