topic Re: Re: Creating start - end calendar date in QlikView

Creating start - end calendar date

Wed, 23 Apr 2014 18:21:39 GMT

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?

Re: Creating start - end calendar date

swuehl — Wed, 23 Apr 2014 18:46:17 GMT

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

Re: Creating start - end calendar date

Wed, 23 Apr 2014 19:18:17 GMT

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?

Re: Creating start - end calendar date

Wed, 23 Apr 2014 19:25:23 GMT

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?

Re: Creating start - end calendar date

swuehl — Wed, 23 Apr 2014 19:35:26 GMT

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.

Re: Creating start - end calendar date

Wed, 23 Apr 2014 19:46:10 GMT

and how do I do that exactly? O.o

Re: Re: Creating start - end calendar date

swuehl — Wed, 23 Apr 2014 21:17:36 GMT

Similar to attached.

Re: Creating start - end calendar date

Thu, 24 Apr 2014 17:05:00 GMT

Thank you, this one is worthy working with (: