Null values

[francis_gr]

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

[johnw · Accepted solution]

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

[francis_gr]

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