topic Re: Force Today()'s date in List Box in QlikView

Force Today()'s date in List Box

Tue, 04 Sep 2012 00:27:01 GMT

I need to be able to force the application to start up with the current date. I tried this with the formula:

=INSPDATE = Today()

in the Expression of the List Box. It creates a two row box with a 0 an -1, which allows me to click on the -1 and bring up Today's date, but does NOT force the current date on a regular reload. Any ideas? I'd rather just have it bring up the application with today's date already selected in the calendar. JPT

Re: Force Today()'s date in List Box

Jason_Michaelides — Tue, 04 Sep 2012 06:53:01 GMT

Go to Settings > Document Properties > Triggers and add an OnOpen action. Choose Select in Field, then put INSPDATE in the field box and =Today() in the expression.

If your field INSPDATE is not formatted as the system date is you may need to wrap Today() in Date().

Hope this helps,

Jason

Re: Force Today()'s date in List Box

Thu, 06 Sep 2012 13:37:10 GMT

Jason, I very much appreciate your help with this issue. I didn’t want to reply until I had a chance to give it a try, and I gave it several, but to no avail. I tried both the OnOpen and the OnPostReload Triggers, and I focused the field on the PeriodDate of the MasterCalendar. I cleared all selections and saved it, but upon opening … nothing. JPT

//Building the master calendar with most date dimensions

MasterCalendar:

load PeriodDate ,

Year(PeriodDate) & Month(PeriodDate) & NUM(Day(PeriodDate), 00) as LinkDate,

week(PeriodDate+1) as Week,

DateKey,

Year(PeriodDate) as Year,

Month(PeriodDate) as Month,

Day(PeriodDate) as Day,

Year2date(PeriodDate)*-1 as CurYTDFlag,

Year2date(PeriodDate,-1)*-1 as LastYTDFlag,

date(monthstart(PeriodDate),'MMM-YYYY') as ,

//if(week(PeriodDate)>= $(CurWeek) -3 and week(PeriodDate) <= $(CurWeek) and year(PeriodDate) = 2004,1,0) as FourWeekFlag,

Week(PeriodDate+1) as CalendarWeek,

Week(PeriodDate+1)&'-'&Year(PeriodDate) as WeekYear,

weekday(PeriodDate) as WeekDay

resident TempCalendar order by PeriodDate Asc;