topic Re: set analysis or operator in QlikView

set analysis or operator

Wed, 23 Oct 2013 17:59:22 GMT

Ive created a button and want it to select all dates larger 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 larger than today but the second part does not work.

How do i do to solve this?

Thanks!

Gysbert_Wassenaar — Wed, 23 Oct 2013 18:55:55 GMT

Try ='(>=$(=date(today())) | 2 )'

date(1900-01-01) is date(1898) is somewhere in 1905. num(date#('1900-01-01','YYYY-MM-DD')) = 2. You could use a variable for that:

vOrDate = num(date#('1900-01-01','YYYY-MM-DD'))

and as search string ='(>=$(=date(today())) | $(vOrDate) )'

offjunior — Wed, 23 Oct 2013 20:02:20 GMT

Good afternoon friend!

See if that helps you. If you do not help, send me a document qvw with an example of what you are needing.

= '>=' & Date(Today(), 'DD-MM-YYYY') & '<=' & Date('1900-01-01', 'DD-MM-YYYY')

Following is a document attached to qvw you see in practice.

HUG!

Thu, 24 Oct 2013 07:39:54 GMT

= '>=' & Date(Today()) & '<=' & Date('1900-01-01')

works perfectly.