Creating start - end calendar date

[#1]

hey guys,

I have this date field called [Claim Close Date], and I want to create two calendars, one for a start date selection, and one for the end date selection in this field. So, it would be a Calendar where they choose the start date, and another calendar where they choose the end date. In both the field is this [Claim Close Date]. Customer will be able to pick a start and a end of the selections.

How do I do that?

[swuehl]

This should be a good guide http://community.qlik.com/docs/DOC-4247

[#3]

The link between the "Start date" and "End date" calendars, is through this formula?

Sum({< CalendarDate = {'>=$(=Date(vStartDate))<=$(=Date(vEndDate))'} >} SalesAmount)

???

Do I have to add this set analysis in all my graphics, so it would work choosing in the calendars? I wanted not to have this set analysis added to all my graphics, too much work... or don't i need that?

[#4]

Added to it, if I choose in a simple box with Year([Claim Close Date]) the values where I used the set analysis doesn't get affected, because the variables did not change, so, either I have everything being used in terms of [Claim Close Date], or, everything in terms of the VStartDate and VEndDate...

Or do I have a way out of this?

[swuehl]

Instead of the set analysis, you can use an action to select on your field depending on your two calendar variable, triggered by a button or the calendar variable change.

[#6]

and how do I do that exactly? O.o

[swuehl · Accepted solution]

Similar to attached.

[#8]

Thank you, this one is worthy working with (: