topic Re: How to make a default selection of max date with "always one selected value"? in App Development

How to make a default selection of max date with "always one selected value"?

Oleg — Sat, 16 Nov 2024 02:18:59 GMT

I need to make a default selection for the date field so that the maximum date is chosen when I open the app. I have managed to do this:

date={"=[date] = max(total [date])"}

The problem is, I want this field to have the "always one selected value" option enabled, but when I do this, a wrong date gets selected. I have tried "{1}" instead of "total" which didn't help.

Please, tell me, how should I deal with this problem? Thank you.

Re: How to make a default selection of max date with "always one selected value"?

bhaskar_sm — Thu, 28 May 2020 11:38:14 GMT

Hi,

basically I have worked on your problem statement and able to get the working one by creating an additional column which only has a max date and linked with a Date column. this solution work whenever you have a new date in the data.

Script:

T1:
Load Date#( Date,'DD-MM-YYYY') as DATE, num#(Date) as DATE_NUM;
Load * inline [
Date
28-04-2005
02-06-2005
03-06-2005
04-06-2005
05-07-2016
15-01-2005
12-09-2005
05-09-2004
17-11-2004
29-08-2004
20-06-2004
08-10-2004
21-04-2005
11-12-2005
06-06-2004
23-06-2004
15-07-2004
27-02-2004
14-08-2004
12-03-2004
15-08-2004
04-01-2004
13-08-2004
11-03-2004
];

NoConcatenate
Load Max(DATE) as DATE_N,DATE(Max(DATE),'DD-MM-YYYY') as DATE Resident T1 Order by DATE_NUM desc ;

Front End:

Re: How to make a default selection of max date with "always one selected value"?

Oleg — Mon, 01 Jun 2020 09:41:11 GMT

Thank you, but as far as I understand, this solution won't allow me to choose different dates, so that the max date is always chosen, right? I need to be able to let the user choose any date.

Re: How to make a default selection of max date with "always one selected value"?

parayu — Wed, 21 Apr 2021 14:01:43 GMT

Hello guys,

I have exactly the same issue and couldn't find any solution. Is this a Qlik Sense limitation maybe?

Thanks,

Bogdan

Re: How to make a default selection of max date with "always one selected value"?

Rick_07011 — Thu, 09 Nov 2023 10:38:17 GMT

Have a look at this link Solved: Dynamic Default Bookmark with 'Always one selected... - Qlik Community - 1657592

I used the answer of @eero_h and it worked