Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Default Date (current month&year) on calender object

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:  

cal.JPG.jpg

but am expecting  like DEC 2014 here as by defualt,

please help me on this

Regards

Damodhar

2 Replies
ecolomer
Master II
Master II

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

p10.png

its_anandrjs

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

calendarob.png

Regards

Anand