topic Default date on calendar object in QlikView

Default date on calendar object

Wed, 25 May 2011 13:10:35 GMT

I have a calendar object and for the data field I have the following expression:

=date(SALE_DATE, 'MM/DD/YYYY')

The dates range from 2009 to 2011. When I click the calendar icon to bring up the date selector the selector is defaulted to Jan 2009. I want it to default to the current month and year. I don't want to select a date, I just want the calendar pop-up to show the current month and year when clicked. Any ideas? Thanks.

Here's how it looks now:

Default date on calendar object

Wed, 25 May 2011 13:27:38 GMT

Moshea,

The Community Corner is for QlikCommunity-related questions; I'm moving this to the Development community.

Kindly,

Jason

Default date on calendar object

Wed, 25 May 2011 14:57:17 GMT

ok thanks Jason

Default date on calendar object

Wed, 23 May 2012 19:32:39 GMT

I believe you can let a variable in your script and then use it in your calendar. So this variable will be set each time you reload the script.

Re: Default date on calendar object

Fri, 25 Oct 2013 08:33:53 GMT

Any update to this?

The calendar object just defaults on the lowest available date no matter what you sort on.

Re: Default date on calendar object

sibrulotte — Mon, 28 Apr 2014 20:53:50 GMT

Same issue,

haven't found an answer.

Just so everyone is clear: The calender is set to modify a field, hence data : Field.

By default, the calendar shows the lowest date value (like showed above, where it's at January 2009),

but we'd like it to be at today's month and year.

Thank you for the community efforts

Re: Default date on calendar object

Clever_Anjos — Tue, 29 Apr 2014 00:58:25 GMT

Check if fit your needs

Re: Default date on calendar object

jagan — Tue, 29 Apr 2014 04:13:38 GMT

Hi,

Create a variable

vToday = Today()

Now in Calendar object set

Max Value =YearEnd(vToday)

Min Value = YearStart(vToday, -1)

The above expressions will set the Current month as default month and year and limits the calendar for year 2013 and 2014, if you want to extend change the above expressions.

Refer attached file for solution.

Regards,

Jagan.

Re: Default date on calendar object

jaimeaguilar — Tue, 29 Apr 2014 21:10:55 GMT

Hi,

you may use a trigger (action) and a variable to set a date everytime you open a tab,

regards

Re: Default date on calendar object

sibrulotte — Wed, 07 May 2014 19:38:43 GMT

That works great for a variable. Because your setting a variable, and everyone is happy that the variable then selects a date. Great.

But I need this to be a field selection from the start to have Multi-value.

Does anyone know if that is possible?

Alternatively I could go "concat" the variables of two calendars in the trigger action to bring back an interval of dates. But that does not meet the client requirements to select multiple dates in one calendar, that are not necessarely consecutive.

Re: Default date on calendar object

Wed, 02 Jul 2014 10:33:19 GMT

Hi jagan,

I am also using the similar approach ,but I have a problem.

When I select a different date ,calender is showing the numerical representation of the date selected.I have checked with your test application and it is also having same problem.

how to avoid that and show the actual date format in the calender object?

Many thanks for your help.

Regards

Murali Krishna