topic Setting default date selection on load in QlikView

Setting default date selection on load

mazacini — Wed, 08 Jun 2011 21:09:15 GMT

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

Setting default date selection on load

Anonymous — Wed, 08 Jun 2011 22:23:31 GMT

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.

Setting default date selection on load

mazacini — Thu, 09 Jun 2011 07:21:17 GMT

Hi Johannes

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

Re: Setting default date selection on load

mazacini — Thu, 09 Jun 2011 21:31:08 GMT

Hi Johannes

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

=DATE(Max( "DATE"))