topic Re: Is it possible to select everything that doesn't have a value for a specific field from a table? in QlikView

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

Thu, 20 Oct 2011 20:26:13 GMT

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.

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

erichshiino — Fri, 21 Oct 2011 12:33:17 GMT

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

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

Fri, 21 Oct 2011 15:47:55 GMT

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