Evaluation of the last days

[dominicanlauf]

Hello everybody,

I created an evaluation in Qlikview that shows information about how productive the production is (plant availability, reject rate, etc.). The Evaluation works that way: I select the days I want to compare in my multibox (filter).

However, since the evaluation is also to be used in production, the last (most recent) two or three days should automatically be displayed for the values, without me having to select the date each time.

How can I achchieve this?

Thanks and best regards,

Dominic

[Gysbert_Wassenaar]

You can try using the OnOpen document trigger with a Select in Field action. You can find the document triggers on the Triggers tab of the document properties window. You'll need a search expression for the selection of the last dates. Something like ='=MyDate>=$(=Max(MyDate)-2)'

[dominicanlauf]

Thanks for answering my question.

I found the Trigger - but unfortunately, I don't know the right Expression.

Do you have a Special advice for this?

Thanks!

[Gysbert_Wassenaar]

Have a look at some of the discussions this search returns: https://community.qlik.com/t5/forums/searchpage/tab/message?q=onopen%20trigger%20select%20dates&coll...

And/or post a small qlikview document with example data.