topic Select most recent date as default selection in QlikView

Select most recent date as default selection

Wed, 01 Sep 2010 13:36:43 GMT

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

Select most recent date as default selection

tresB — Wed, 01 Sep 2010 13:53:31 GMT

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

Select most recent date as default selection

Clever_Anjos — Wed, 01 Sep 2010 13:53:38 GMT

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

"Select in Field"

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

Select most recent date as default selection

tresB — Wed, 01 Sep 2010 14:02:25 GMT

Hi,

Put the Date() as :

=Date(Max(DateField))

and find the Attachment for reference.

Regards,

..tresesco

Select most recent date as default selection

Wed, 01 Sep 2010 14:02:59 GMT

Check out this thread for more ideas on this subject:

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

Select most recent date as default selection

Wed, 01 Sep 2010 14:04:55 GMT

Thanks you all, it was helpful.

Select most recent date as default selection

Sat, 30 Jul 2011 01:17:37 GMT

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.