topic Script syntax to exclude null values when loading in QlikView

Script syntax to exclude null values when loading

Wed, 05 Sep 2012 13:11:27 GMT

Re: Script syntax to exclude null values when loading

Wed, 05 Sep 2012 13:34:48 GMT

change all of your like to =

and for your question

AND status <> Null()

However, i notice you are using a resident to do this. If you are loading the data from a SQL query you could nip all this effort from that point and limit your data intake right away.

Also, you aren't really going to get much from this...

Two fields that say the same thing...U_S and status saying Accepted and Accepted????

Re: Script syntax to exclude null values when loading

kouroshkarimi — Wed, 05 Sep 2012 13:37:16 GMT

Please use the match function instead: where match(status,'Accepted','Awaiting Finance','Awaiting Initial Approval',..etc) I think it's much easier to read.

Re: Script syntax to exclude null values when loading

kouroshkarimi — Wed, 05 Sep 2012 13:54:43 GMT

If you're creating a table using 'distinct status' and 'status' then you're just creating a table which holds two columns that have the same values. Unless one of the status fields is from another table, in which case it would explain the nulls.