topic Re: set analysis or operator in QlikView

set analysis or operator

Wed, 23 Oct 2013 17:56:45 GMT

Ive created a button and want it to select all dates smaller than 'Date' OR 'Date'=1900-01-01

The code ive got is:

='>=$(=date(today())) OR =$(=date(1900-01-01))'

but it doesnt work.

The first part of the code, ie ='>=$(=date(today())), is working and selects all dates smaller than today but the second part does not work.

How do i do to solve this?

Thanks!

tresB — Wed, 23 Oct 2013 18:01:43 GMT

'+' is used for 'OR' in set analysis. But again that has it's way. Could you paste here your entire expression?

Wed, 23 Oct 2013 18:05:05 GMT

='>=$(=date(today())) is the whole expression. It is inside a button.