max date by default

[Fab62400]

Hello,

I have a database with a PERIOD field which represents the date on the first of the month (aggregation of data on 01 / month / year).

How can we put by default in a pane filter the last date or the maximum PERIOD field?

Or can we assign a formula to a favorite (here for example PERIOD = max (PERIOD))?

Thanks for your help!

[Kushal_Chawda]

you can use below

=date(max(total DateField))

[Fab62400]

Where do you put it  ?  in bookmarks?

[Kushal_Chawda · Accepted solution]

you can show in filter pan but if you need bookmark then refer  below

https://community.qlik.com/t5/Qlik-Sense-App-Development/Default-Selection-of-Max-Date/td-p/1662555

[Fab62400]

it does not work.

I would like that at the opening of the sheet the filter is done automatically on the maximum of the date.

[Kushal_Chawda]

Did you try the solution provided in link described in my previous reply?

[Fab62400]

Indeed, I wanted to go too fast.

Thank you for the answer.

I put    =PERIODE=max({1} total PERIODE)  anf  hitting the enter key .

[Fab62400]

and I saved the bookmark and set it as default.