topic Re: Database load (SQL) with null values in QlikView

Database load (SQL) with null values

Tue, 15 Jan 2013 08:35:34 GMT

Hi all,

I want to load some data from a SQL server database but would like to filter out null values for a specific field. The standard 'is null' statement does not seem to work. Any ideas?

Cheers!

Erik

Re: Database load (SQL) with null values

nirav_bhimani — Tue, 15 Jan 2013 08:39:09 GMT

Try this statement in the script after From Clause

Where len("Category") <> 0;

In place of category write your field name.

Regards,

Nirav Bhimani

Re: Database load (SQL) with null values

Anonymous — Tue, 15 Jan 2013 09:02:47 GMT

I also have to do this sort of test of lenght as I've not found a way to test the negative of a IsNull() function. Is tihs accepted practic ?

Jonathan

Re: Database load (SQL) with null values

Tue, 15 Jan 2013 09:34:53 GMT

That does not seem to work. But after trying again I found that the 'is null' statement does work.

Load

where not Field1 is null