Is it possible to select everything that doesn't have a value for a specific field from a table?

[#1]

There are some fields that do not have a value in a table I hav and I want to select them.  These fields show a '-' when put into a table, but clicking on thise '-' does nothing.  Is it possible to select the blank ( '-' ) columns?

I have tried using 'select excluded' but I am unable to get it to fit my need.

Thanks in advance for any help.

[erichshiino]

Hi, Tyler.

It's not possible to select null values ( that usually appear as '-' in charts).

The select excluded will not work as well because it get the values that are not selected but not nulls.

You will have to manage this nulls on your script if you need to really make a selection.

Try looking for the NullAsValue option on the script or a  nullcount as an expression on a chart

If you post an example, we can try to help you out

Regards,

Erich

[#3]

It's true that you cannot select null values. But, you can usually get the data you want by making a selection on a different field where your original field is null. See this description of how to do it (paste the url into your browser): qlikviewmaven.blogspot.com/2010/10/selecting-null-values.html