topic Re: Selecting Dates based upon Input in QlikView

Selecting Dates based upon Input

Fri, 15 Jan 2016 19:09:43 GMT

I know I've seen this topic before but I'm looking to go a little farther. What I am trying to do is allow for the user to input a start date and an end date and then click a button that will apply to filter and select only the dates between them. That part is working.

I also want to select the previous year for the same time frame as well.

For example, if the start date is 1/7/2013 and the end date is 1/13/2013, I would like 1/7/13 - 1/13/13 selected as well as 1/7/12 - 1/13/12.

I am using a SELECT IN FIELD action on a button to do this. The current search string is:

='>='&date(vStartDate) & '<=' & date(vEndDate)

That works. Anyone know how to add to that to allow the previous year dates to be selected as well? I have uploaded my sample. !

Re: Selecting Dates based upon Input

sunny_talwar — Fri, 15 Jan 2016 20:23:38 GMT

Try this:

='(">='&date(vStartDate) & '<=' & date(vEndDate) & '"|"' & '>=' & date(AddYears(vStartDate, -1)) & '<=' & date(AddYears(vEndDate, -1)) & '")'

Re: Selecting Dates based upon Input

Fri, 15 Jan 2016 20:29:20 GMT

Thank you very much for the quick response! I was so close. For the | part I missed the double quotes inside the single.