topic Re: Apply Default selection to previous month on App open in App Development

Apply Default selection to previous month on App open

AnithaLux — Thu, 22 Sep 2022 14:01:04 GMT

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"

Re: Apply Default selection to previous month on App open

RafaelBarrios — Thu, 22 Sep 2022 16:04:31 GMT

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,

Re: Apply Default selection to previous month on App open

AnithaLux — Fri, 23 Sep 2022 12:14:33 GMT

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.

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

Re: Apply Default selection to previous month on App open

RafaelBarrios — Fri, 23 Sep 2022 12:57:42 GMT

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,

Re: Apply Default selection to previous month on App open

KanikaD — Tue, 27 Feb 2024 07:17:13 GMT

Was this resolved? How did you achieved it?

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