Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

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
Master III
Master 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
Master III
Master 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
Creator
Creator

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

Try this:

='>=08/05/2016'

Highlighted
Creator
Creator

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
Creator
Creator

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

Thanks

Highlighted
Creator
Creator

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)