Apply Default selection to previous month on App open

[AnithaLux]

Implement a default selection on the app to the previous month. Currently the datamodel has a period field formatted to 'MMM-YYYY' . On open ,a default selection should be applied to the App to the prev month . we must be able to re-select if needed. Ex: Lets say the current month is SEP 2022. On App open we should be able to point to previous month AUG 2022. The user must also be able to select JULY 2022 if needed as well. The Period field setting is checked for "Always select one value"

[RafaelBarrios]

Hi @AnithaLux 
you can try trigger in sheets properties with value

=date(AddMonths(now(),-1),'MMM YYYY')

you may need to use some IF conditions so trigger not always apply

Best,

[AnithaLux]

I tried this but this does not work for date fields.

Adding actions to sheets ‒ Qlik Sense on Windows

Select values in a field

You can select a list of values in a field that you specify. Separate the values to select with a semi colon. You can optionally overwrite locked selections.

Information noteIt is not possible to use fields with date, timestamp, or money data type.

[RafaelBarrios]

interesting, i will try that..

you can also try to toggle.

in the same link you provided

Toggle field selection

You can set the button to toggle between the current selection, and a selection that adds selections defined by a search string. You can use wild cards in the search string. If you want to define a list of values you need to use the format (A|B), where A and B are values to select.

ill try and get back to you

best,

[KanikaD]

Was this resolved? How did you achieved it? 

I am trying to same thing. But not able to achieve. Thanks