Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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

Re: Button to Select range is date field

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

4 Replies
Not applicable

Re: Button to Select range is date field

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

Not applicable

Re: Button to Select range is date field

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

Re: Button to Select range is date field

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

Re: Button to Select range is date field

i'm sure

post sample file and let me check the problem