Always select the latest date (max) for multiple date fields

droonu194 — Tue, 04 Apr 2023 16:52:15 GMT

Hi Qlik Guru's,

I am facing a very interesting problem that I am trying to make work.

The app I'm building out is a proof of concept based on a table.

[Philosophy_Text]:
phi_id,
phi_category,
phi_comment,
phi_date

from [lib://....]
where match(text_category, 'Philosophy');

The output should always return the [phi_comment] based on the latest [phi_date]. I have that working by using the firstsortedvalue function.

The problem: I'd like to always have the latest date selected when a user enters the app. That way, the user will always see the last comment, where the category is Philosphy, based on the latest date (sorted descending).

Tried to follow along this forum (https://community.qlik.com/t5/App-Development/Default-Selection-of-Max-Date/td-p/1662555) but was having trouble entering that formula.

Thank all!

Re: Always select the latest date (max) for multiple date fields

Sabrina_V — Wed, 05 Apr 2023 06:41:39 GMT

Hello,

You need to use a bookmark applied by default. On the filter "phi_date" tape this formula : =max(phi_date) and save it in the bookmarks. Before saving the bookmark check the summary of the selections saved. You should see the formula you taped before.

topic Always select the latest date (max) for multiple date fields in App Development

Always select the latest date (max) for multiple date fields

Re: Always select the latest date (max) for multiple date fields