topic Default Date (current month&year) on calender object in QlikView

Default Date (current month&year) on calender object

Sat, 06 Dec 2014 07:32:41 GMT

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

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

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:

but am expecting like DEC 2014 here as by defualt,

please help me on this

Regards

Damodhar

Re: Default Date (current month&year) on calender object

ecolomer — Sat, 06 Dec 2014 07:49:30 GMT

You need to put Limit inf. at =Today()

Re: Default Date (current month&year) on calender object

its_anandrjs — Sat, 06 Dec 2014 08:09:44 GMT

Hi,

Then create two fields based on the current datefield which is running on your model and on the basis of that create a table to find the Min and Max dates

LOAD Date(Min(DateField)) as MinDate, date(Max(DateField)) as MaxDate Resident Raw;

And create a variable Let vTodaysDate = Today();

And then in the calendar object use this variable vTodaysDate and in the min value MinDate and in Max MaxDate

Regards

Anand