topic Re: Setting dynamic filters in App Development

Setting dynamic filters

revokark — Mon, 10 Mar 2025 14:00:09 GMT

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

Re: Setting dynamic filters

henrikalmen — Mon, 10 Mar 2025 14:28:47 GMT

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

Re: Setting dynamic filters

revokark — Mon, 10 Mar 2025 15:26:20 GMT

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?

Re: Setting dynamic filters

henrikalmen — Mon, 10 Mar 2025 15:43:32 GMT

=metadata_run_number=Max({1} TOTAL metadata_run_number)

Re: Setting dynamic filters

henrikalmen — Mon, 10 Mar 2025 15:57:24 GMT

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)