Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
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

Try this

='>08/05/2016'

View solution in original post

7 Replies
Highlighted

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

Try this

='>08/05/2016'

View solution in original post

Highlighted
Creator
Creator

Try this:

='>=08/05/2016'

Highlighted
Creator
Creator

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

Highlighted
Creator
Creator

Thanks

Highlighted
Creator
Creator

Worked brilliantly thank you

Highlighted

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)