topic Can I select the range of dates using the calender object in QlikView

Can I select the range of dates using the calender object

Thu, 01 Jul 2010 18:22:37 GMT

Hi All,

I want to use one calender object to select the from date and the other calender object to select the to date. For example, as shown below if select 01/01/07 in "Date From" and 31/07/07 in the "Date To" then it should the date range from 01/01/07 to 31/07/07.

Some one please let me know how it can be done.

Can I select the range of dates using the calender object

johnw — Thu, 01 Jul 2010 20:58:16 GMT

I believe those would need to be separate fields, and then you'd kick off actions or a macro to select that range of data in the real date field. I tried that recently with actions, and for some reason didn't get it to work. Probably just my lack of familiarity with actions (we're in the middle of upgrading from 8.5 to 9.0).

It's not exactly what you're asking for, but I've achieved the same result with a multi-value slider bar for the date.

Can I select the range of dates using the calender object

Thu, 01 Jul 2010 21:10:43 GMT

Sure. Something like this.

Can I select the range of dates using the calender object

johnw — Thu, 01 Jul 2010 21:21:37 GMT

Thanks, Nick. Saved for reference so I don't have to keep saying "should be easy, but I couldn't make it work" when people ask this question. 🙂

Can I select the range of dates using the calender object

Thu, 01 Jul 2010 21:53:20 GMT

Sure. Your are always welcome.

Can I select the range of dates using the calender object

Fri, 02 Jul 2010 07:40:27 GMT

Hi Nick,

Thanks a ton for your help. That was a great work!

It is working fine in yours but the same thing is not working in mine. I am not sure where the mistake is but I think it must some silly mistake only. Can you please check with attached document which I worked with.

Can I select the range of dates using the calender object

Fri, 02 Jul 2010 23:30:29 GMT

Check all Triggers from the Document Settings in my example

Can I select the range of dates using the calender object

Mon, 05 Jul 2010 12:20:31 GMT

Hi Nick,

I have added the same triggers now but still there are some problem with that. The value which I am selecting in the form and to calender is getting affected only in the slider and there is no change in the other object. Whereas if I select something in the slider, from and to calender is not getting affected but other object are getting affected.

Have attached the same application which I am working around. Requesting you to check it out when it is not working as expected.

Can I select the range of dates using the calender object

Thu, 08 Jul 2010 15:17:00 GMT

Can you send the QVW file where you try to implement it?

Can I select the range of dates using the calender object

Fri, 09 Jul 2010 08:18:06 GMT

Hi Nick,

Now it seems to be working don't know where the mistake was before.

But one thing doesn't seems to be working in my end was when I press the clear button it is not clearing off the dates(values) in both the calender object. Not able to make it out where the issue is.

Could you please check it out. I have attached the document for you which I am working on.

Can I select the range of dates using the calender object

Fri, 09 Jul 2010 08:39:58 GMT

Hi There

You could add a button that runs the macro below, which will "reset" the variables back to the way you have them initialised..

sub reset_vars
 set doc=ActiveDocument
set vars = doc.GetVariableDescriptions
 doc.Variables("vStartDate").SetContent "39814", true
 doc.Variables("vEndDate").SetContent "39854", true

set vars = nothing
 set doc = nothing
end sub

You still need to "Clear" the other data though - and this can be achieved by another button with a Clear All action attached to it.

Can I select the range of dates using the calender object

Fri, 09 Jul 2010 10:33:45 GMT

Hi Graeme!

Many thanks for your suggestions. But I think there must be some other way to do the same. Please look into the document attached by Mr. Nick. In that document date fields are getting cleared without the help of macro. So there must of the other way to do so.

Hope Mr. Nick can answer for us.

Have attached Mr. Nick's document for your reference.

Can I select the range of dates using the calender object

Fri, 09 Jul 2010 11:07:55 GMT

At a guess, you're hardcoding the Start and End dates in the script ?

LET vDateMin = Num(MakeDate(2009,1,1));
LET vDateMax = Floor(MonthEnd(Today()));
LET vDateToday = Num(Today());

Can I select the range of dates using the calender object

Fri, 09 Jul 2010 11:27:14 GMT

Hi Graeme,

May be but I don't know. Is it the one creating problem here. It is hard coded just because it is getting retrieved from the master calender.

Do you think it is creating problem here.

Can I select the range of dates using the calender object

Fri, 09 Jul 2010 12:13:17 GMT

Yes in my opinion.

The only way to "clear" it, is either use Nik's method for calendar creation, or the buttons I described above....

Can I select the range of dates using the calender object

Fri, 09 Jul 2010 13:08:18 GMT

Check Document Event Triggers. I'm using OnAnySelect action to clear the Start/End Date variables by expression like this:

=if(len(GetFieldSelections(Date)), vStartDate)
=if(len(GetFieldSelections(Date)), vEndDate)

Check another Document Event Trigger for OnOpen Event also.