Automatically selecting last day through sheet actions

[EliGohar]

Hi all,

Version: Qlik Sense May 2024 Patch 10

I want to make an automatic selection when entering a specific sheet - select the last day in the model.

I created this sheet action:

This action should always select 22/12/2024 (Max date is 23/12/2024). 

But the problem is that every time I enter the sheet, a day is subtracted and the date decreases by a day... This means that the first time I enter, the selection will be 22/12/2024, on another entry the selection will be 12/21/2024, etc.

What's wrong? Am I missing something?

Thanks for your help,

Eli.

[MatheusC · Accepted solution]

Hi, @EliGohar 

Try ignoring your date selection field, something like:

=Date({<Date=>}Max(Date)-1)

- Regards, Matheus