Select most recent date as default selection

[#1]

Hello Everyone

I need assistance. I have historical data loaded. I want the Qlikview document to always open with the most recent date selected, there after I can select any other historical date.

I would truelly appreciate some help.

Regards

Karabo

[tresesco]

Hi Karabo,

I would prefer a trigger for this.

Go to Document Settings ->Triggers->DocumentEventTriggers->Select "OnOpen" -> Click AddAction->Add ->Selection->Select In Field->OK

Then you have to put your datefield in the "Field" and put : =max(DateField) in the "Search String"

Hope this helps.

Regards,

tresesco

[Clever_Anjos]

You can set a trigger based on "OnActivateSheet" or "OnOpen" and set action as below

"Select in Field"

=

date(max(YourField),'MMM/YYYY')

[tresesco]

Hi,

Put the Date() as :

=Date(Max(DateField))

and find the Attachment for reference.

Regards,

..tresesco

[#5]

Check out this thread for more ideas on this subject:

http://community.qlik.com/forums/t/21406.aspx

[#6]

Thanks you all, it was helpful.

[#7]

Thanks tresesco for providing this example. It helped me achieve the capability being discussed here.

Wanted to add that I was only able to get it to work after having some things set just so:

First:

The entry in "Field" had to be "Date" not "=Date". Not obvious to me and frustrated me for several minutes.

Second:

The entry in "Search String" had to be: "=Date(Max({1} Date))". (For those who read this and wonder, read about set analysis to understand the {1} part).

Only by having the entries like this was I able to get this example to work.

Hope this feedback helps others.