topic Issues with selecting multiple things with Select in Field in QlikView

Issues with selecting multiple things with Select in Field

Wed, 25 Nov 2020 16:16:04 GMT

I am having some issues selecting in field for both nulls as well as dates after a certain value.

I brought the nulls in as values with:

NULLASVALUE *;

I can also separately select with: ='' to find nulls and ='>='&begindate to find dates greater than a variable.

I however cant seem to get both to select at the same time.

Other online content seems to suggest ='(' & '' & '|' & '>=' & begindate & ')'

but I have not be able to achieve success with this/

Re: Issues with selecting multiple things with Select in Field

sunny_talwar — Thu, 09 Mar 2017 20:24:05 GMT

Would you be able to share a sample to better demonstrate what you are trying to do?

Re: Issues with selecting multiple things with Select in Field

Thu, 09 Mar 2017 20:33:33 GMT

I have a field that contains dates and nulls. Here is a subset of that field. Nulls indicate not closed.

I have a date variable that I am defining with a calendar that I am triggering on.

I am wanting to select anything after that variable as well as any nulls. I can do each of these separately with success just not together.

Re: Issues with selecting multiple things with Select in Field

Fri, 10 Mar 2017 13:39:42 GMT

Figured out my issue. I was assuming Qlikview handled the loaded null values as less than my date value. However it seems like it handled them as having no relation (IE not <,>,=, or <>). So I was able to make my selection with a combination of Selecting in Field all values less than my date and then doing a Select Excluded.