Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mazacini
Creator III
Creator 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
Anonymous
Not applicable

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
Creator III
Creator III
Author

Hi Johannes

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

mazacini
Creator III
Creator III
Author

Hi Johannes

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

=DATE(Max( "DATE"))