topic Re: Re: Select all dates within past year. in QlikView

Select all dates within past year.

Wed, 12 Mar 2014 19:00:13 GMT

Hi,

I am having trouble selecting dates from a field that are from within the past year. I want to select all dates from my "myDate" field that are within the past year with the click of a button. I am able to accomplish similar functionality for a field with integer values. I've attached an example of my problem.

Any help will be greatly appreciated.

Thanks,

Ryan

Re: Select all dates within past year.

Wed, 12 Mar 2014 19:36:19 GMT

Hi Ryan,

You don't need an input box. Attached with answer. Please look at the trigger expression in the button.

Thanks

Re: Re: Select all dates within past year.

MK_QSL — Wed, 12 Mar 2014 19:49:48 GMT

Please check enclosed file which will help you to select between two dates...

UPDATE : for your application, you can use as below...

='>='&Timestamp('$(vRollingMonth)')

For MaxDate until today...

='>='&Timestamp('$(vRollingMonth)')&'<='&Timestamp(Today())

Re: Re: Select all dates within past year.

Wed, 12 Mar 2014 20:36:54 GMT

Thanks, works like a charm.

Re: Re: Select all dates within past year.

Wed, 12 Mar 2014 20:38:24 GMT

Many thanks -- works like a charm.