Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Button to Select range is date field

Hello,

I am attempting to create a button that sets a date feild to all dates in the past week. Essentially I need to set the field to >Today-8. I have been trying to add a "Select in Field" action that will do this with no luck. Any help would be great.


Thanks!

Jeff

1 Solution

Accepted Solutions
Not applicable
Author

='>$(=date(today()-8))'

View solution in original post

4 Replies
Not applicable
Author

='>$(=date(today()-8))'

Not applicable
Author

I'm not sure how this was implemented, but I'm trying to do the same thing and in the context of a "Select In Field" button, neither this

='>$(=date(today()-8))'

nor this

=date(today()-8)

or this

>$(=date(today()-8))

work at all in the button. Are you sure this is exactly what must be pasted in the search string area? I've got "Select In Field" for the button, and "=add_date" in the Field area (no quotations). Any help? I'd rather not post a duplicate question if I can avoid it.

Not applicable
Author

I was unable to make this work using "Today()". However , I have a date feild in my mart that if I take the max will equal today (assuming the data refreshed properly). So the string looks like this:

='>$(=Date(max(TranDate)-8))'

Not applicable
Author

i'm sure

post sample file and let me check the problem