topic Re: Exclude blank cells in data in QlikView

Exclude blank cells in data

Sunil_Kenth — Mon, 12 Mar 2012 16:36:39 GMT

Hi,

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

Thanks,

Sunil

Sunil_Kenth — Mon, 12 Mar 2012 16:37:12 GMT

This is in my load script by the way.

Thanks,

Sunil

Miguel_Angel_Baeyens — Mon, 12 Mar 2012 16:38:30 GMT

Hi Sunil,

I prefer to use

Table:
LOAD *,
     If(Len(Field) = 0, 'Null', Field) AS Field
... // source here

Hope that helps.

Miguel

Sunil_Kenth — Mon, 12 Mar 2012 16:42:59 GMT

Hi Miguel,

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

Something like:

Where DFLOW <> ‘ ‘ .

jvitantonio — Mon, 12 Mar 2012 16:44:15 GMT

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

Sunil_Kenth — Mon, 12 Mar 2012 16:46:35 GMT

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

jvitantonio — Mon, 12 Mar 2012 16:51:06 GMT

Load * from youtfile.qvd (qvd)

Where DFLOW <> ' ';

Miguel_Angel_Baeyens — Mon, 12 Mar 2012 16:51:45 GMT

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