Setting dynamic filters

[revokark]

Hey!

I would like to know if it is possible to set the filters dynamically. 

for the situation below:

outcome should always be 'failed'

run_number should be the highest value available (every new entry will add an incremented run_number)

run_attempt should be the highest available (sometimes it could be 1, sometimes 2 etc.) this value changes based on the run_number field.

Is it possible? the point is that i won't need to set those values manually every time i open my app.

Thanks 

[henrikalmen]

See this support video on how to create a dynamic default bookmark, this is what you need: https://help.qlik.com/en-US/video/tFyqOigqnUw

[revokark]

Thanks Henrik

So i've watched the video but still wasn't able to get the highest value from the run_number.

Can you help with that?

[henrikalmen · Accepted solution]

 =metadata_run_number=Max({1} TOTAL metadata_run_number)

[henrikalmen]

Note that since run_attempt's max value should be based based on the selected run_number, you probably need to use set analysis to get that one right. Possibly:

=metadata_run_attempt=max({1<metadata_run_number={$(=Max({1} TOTAL metadata_run_number)}>} total metadata_run_attempt)