topic Null values in QlikView

Null values

francis_gr — Wed, 22 Sep 2010 14:22:54 GMT

HI!!

In access you can do a filter if you want that fields with null values doesn.t show.

Expresions in access like not null, <>null or null if you want to show only fields with null values.

In qlikvew doesn`t work so how can I do filters with null values qlikview (script, dimensions an expresions)??

thanks again

Null values

johnw — Thu, 23 Sep 2010 01:59:27 GMT

I'm not quite sure what you're asking. Maybe try using this at the beginning of your script. It might be what you're looking for:

NullAsValue *;

By default, nulls are excluded from the normal associative logic, so can't be selected in list boxes and so on. You can turn this feature on for specific fields by listing them, or for all fields by using *. I've actually never used it, so hopefully I'm not getting it wrong here.

You can also detect nulls explicitly. There's an isnull() function, but it doesn't work well in 64-bit as I recall, so I recommend using the len() function instead. If len(field)=0, then the field is null. So you could, for intance, put something like this in your script, in a dimension, or in an expression:

if(len(field),field,'Null') as field

Null values

francis_gr — Thu, 23 Sep 2010 20:02:21 GMT

Hi John!!

thanks for your reply.

I have followed your advice and I have used len() function and woks fine!!

I`m new using qlkview so don`t understand yuor first solution

NullAsValue *; at the beginning of the scrip. (before 'Load' i belive)

Can you expalin me how it works??

Thanks a lot

Regards