Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
mazacini
Contributor III

Setting default date selection on load

Hi

I have a sheet with various tables and charts with a List Box containing all Dates from a date field (DATE) in one of my loaded tables.

I use the list box to select dates for the table / chart displays.

How can I arrange so that the latest date in the date field is automatically selected upon opening the file.

I have checked the forums and tried setting a trigger On Open>Actions>Select in Field with Field = DATE and Search String = =date(Max(DATE))

It does not work.

Thanks

3 Replies
jsn
Honored Contributor

Setting default date selection on load

If your field DATE is formatted as a correct date (i.e. has an underlying numeric value) you should be able to use =Max(DATE) as the search string in your action.

mazacini
Contributor III

Setting default date selection on load

Hi Johannes

How do I check if my field DATE is formatted as a correxct date?

mazacini
Contributor III

Re: Setting default date selection on load

Hi Johannes

Ignore my last question. Your tip sent me looking in right direction. Correct syntax in this case is:

=DATE(Max( "DATE"))

Community Browser