topic Re: Button to Select range is date field in QlikView

Button to Select range is date field

Thu, 19 Jul 2012 16:20:13 GMT

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

Re: Button to Select range is date field

Fri, 20 Jul 2012 08:50:44 GMT

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

Re: Button to Select range is date field

Sun, 02 Sep 2012 21:44:29 GMT

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.

Re: Button to Select range is date field

Tue, 04 Sep 2012 12:56:39 GMT

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))'

Re: Button to Select range is date field

Fri, 07 Sep 2012 13:06:24 GMT

i'm sure

post sample file and let me check the problem