Select a previous period automatically

[Phara]

Hello,

I have a dimension called ''Exercice période'' in French which mean Period exercice. I want to systematically select the previous month of the period, as an example, we're in November, and when the sheet opens, I want it  to select October automatically. Please note that I already have a Favorite applied on the sheet.

Any expression for that please?

Thank you so much

[rubenmarin]

Hi, you can use the sheet actions to select a value on a field.

With sheet on edit mode go to actions -> Select values on a field -> select the field -> set the expression for the value, it could be =MonthName(AddMonths(Today(),-1)). Or =Date(AddMonths(Today(),-1),'MMM. YYYY')

[anat]

https://community.qlik.com/t5/App-Development/Apply-Default-selection-to-previous-month-on-App-open/...

go through above link if you haven't gone through,

[Muthukumar_77]

You can try this in Sheet action,

=Date(AddMonths(Max(Date#([Exercice période],'MMM YYYY')),-1),'MMM YYYY')

or

=Date(AddMonths(Today(),-1),'MMM YYYY')