Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Certification Exam Sale - 40% off. Register by June 30, 2020. GET DETAILS
Highlighted
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
Highlighted
Honored Contributor III

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

Try this

='>08/05/2016'

View solution in original post

7 Replies
Highlighted

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)
Highlighted
Honored Contributor III

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

Try this

='>08/05/2016'

View solution in original post

Highlighted
Contributor

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

Try this:

='>=08/05/2016'

Highlighted
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.

Highlighted
Contributor

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

Thanks

Highlighted
Contributor

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

Worked brilliantly thank you

Highlighted

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)