Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
dominicanlauf
Contributor III
Contributor III

Evaluation of the last days

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

3 Replies
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)'


talk is cheap, supply exceeds demand
dominicanlauf
Contributor III
Contributor III
Author

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.

talk is cheap, supply exceeds demand