topic Calendar Object in QlikView

Calendar Object

Tue, 20 Sep 2011 13:55:42 GMT

Hi,

I define Min Value = Today() - 365 and the Max Value = Today() + 365.

I want the object open with the date = Today()?

Is there a way to set an default date to the Calendar Object?

Is possible?

Regards,
Nuno Maximiano

Calendar Object

richard_chilvers — Tue, 20 Sep 2011 15:04:03 GMT

The Calendar Object requires you to select a variable or field in the General tab.

I believe the Calendar then opens on the date currently held in that field.

So perhaps you need to use a trigger to populate your variable whenever the Calendar is activated? You can use the Triggers tab on the Sheet Properties for this.

I hope that helps.

Calendar Object

Tue, 20 Sep 2011 15:10:26 GMT

But, how i define this?

- Min Value = Today() - 365
- Max Value = Today() + 365
- Default Value = Today()

Regards

Calendar Object

richard_chilvers — Tue, 20 Sep 2011 15:29:45 GMT

right-click the Calendar Object
select Properties
select the General tab
select Variable and choose from the drop-down
you can now access the Min Value and Max Value - you will see that these can be expressions.

If this helps you, let me know. The default value may be a little more tricky

Calendar Object

Tue, 20 Sep 2011 16:07:28 GMT

When the question arose had defined Variables, The Min Value, The Max Values.

The question is: How a define de default value?

Regards.

Calendar Object

richard_chilvers — Tue, 20 Sep 2011 16:11:50 GMT

You will need to create a variable. Call it Date_Today. Set it equal to Today().

In the Properties I explained above, use this variable for your Calendar. When you use your Calendar, the default will be today. And you can select any date up to 12 months before or ahead.

Regards

Calendar Object

Tue, 20 Sep 2011 16:44:16 GMT

Hi,

I can't use the variable Date_Today because i use another variable to register the selected of the user.

Sometimes this variable has value and the calendar open in the date of the variable -> Ok

The problem is when the varible don't have value (the user can or not) fill the date.
Then, i can't do Today() for my variable.

When my variable is null i want the calendar open with default value = Today. Is possible?

Regards

Calendar Object

richard_chilvers — Wed, 21 Sep 2011 07:59:57 GMT

Hi Nuno

OK. I do not understand everything about your application. But perhaps, when you create the date variable, you set it to have Today() as its default value. If the user changes this, the Calendar object will use that date, otherwise it will use Today().

Does this help?

Regards

Richard

Calendar Object

richard_chilvers — Wed, 21 Sep 2011 08:02:33 GMT

You may also want to look at this earlier entry on the forum:

http://community.qlik.com/message/36557#36557

Calendar Object

Wed, 21 Sep 2011 11:12:27 GMT

I had this idea: " If the user changes this, the Calendar object will use that date, otherwise it will use Today()."

But have one problem, if the user want Today(), he see that the field date have Today() and save the record.

I don't know if the record is to save with date = Today() or not.

Any ideas?

Regard

Calendar Object

richard_chilvers — Wed, 21 Sep 2011 14:10:11 GMT

If the Calendar object opens with (default) date - Today() and the user does not change it, this will be the date used.

I believe it will solve your problem. But I suggest you try it and see

Regards