Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
isciberras
Contributor

When creating a button is it possible to set date greater than specific date?

Hi All,

I created a text object with an action of "Select in field" and all I want to do is set  a date greater than 08/05/2016. I set the field name which contains the date.


In the search string section I just put  >08/05/2016 however this doesn't seem to work. If I write = instead of > the button works fine.


Does anyone know how I can fix this?

Thanks,

Isaac

1 Solution

Accepted Solutions
antoniotiman
Honored Contributor III

Re: When creating a button is it possible to set date greater than specific date?

Try this

='>08/05/2016'

7 Replies

Re: When creating a button is it possible to set date greater than specific date?

Perhaps this?

='>' & Date(MakeDate(2016,05,08),'dd-MMM-yyyy')

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
antoniotiman
Honored Contributor III

Re: When creating a button is it possible to set date greater than specific date?

Try this

='>08/05/2016'

psilva001
Contributor

Re: When creating a button is it possible to set date greater than specific date?

Try this:

='>=08/05/2016'

isciberras
Contributor

Re: When creating a button is it possible to set date greater than specific date?

Thank you very much for your help unfortunately this didn't work.

isciberras
Contributor

Re: When creating a button is it possible to set date greater than specific date?

Thanks

isciberras
Contributor

Re: When creating a button is it possible to set date greater than specific date?

Worked brilliantly thank you

Re: When creating a button is it possible to set date greater than specific date?

Normally, should work. But Format of date issue

='>' & Date(MakeDate(2016,05,08),'DD-MM-YYYY')

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)