topic Dynamic Default Bookmark with 'Always one selected value' in App Development

Dynamic Default Bookmark with 'Always one selected value'

jrromito — Fri, 13 Dec 2019 14:08:20 GMT

Is it possible to set dynamic default bookmarks with 'always one selected value' on a field? For example, in a date field set to a variable with current fiscal period. =DateField=$(vCurrentFiscalPeriod) works well when always one selected value is not set for field, but does not work at all when set for field using this method https://www.youtube.com/watch?v=tFyqOigqnUw.

Is there a way to achieve this without using extensions? I'd like to avoid installing 3rd party extensions without support as they may not work with upgrades.

Re: Dynamic Default Bookmark with 'Always one selected value'

andoryuu — Fri, 13 Dec 2019 21:20:15 GMT

Sadly no - you won't be able to manipulate it directly with bookmarks unless you set up alternate states and set up bookmarks for those alternate states.

Re: Dynamic Default Bookmark with 'Always one selected value'

OlliK — Fri, 10 Jan 2020 09:42:05 GMT

Did you manage to do this with alternate states?

I have the same problem as you. I have an app where I need to have one year selected, but I also want to dynamically set the latest year by default.

I looked into alternate states, but they seem to be designed to be used for grouping up some filters with visuals, and I don't see how they can be used to solve this problem.

Re: Dynamic Default Bookmark with 'Always one selected value'

ni_avoss — Fri, 10 Jan 2020 16:17:38 GMT

facing the same problem.

any help welcome

Re: Dynamic Default Bookmark with 'Always one selected value'

jrromito — Thu, 16 Jan 2020 18:28:40 GMT

I went another route with this by enabling multiple selections and making charts conditional to one selected. Not as desirable, but accomplishes the goal.

Re: Dynamic Default Bookmark with 'Always one selected value'

robin_heijt — Thu, 23 Jul 2020 16:28:48 GMT

Did you ever manage to find a more decent solution for this? I am facing with the same issue.

Cheers

Re: Dynamic Default Bookmark with 'Always one selected value'

Digvijay_Singh — Tue, 01 Jun 2021 18:47:38 GMT

anyone got better alternative?

It used to work for us, not 100% but after upgrade to June 2020 we don't see latest month when data is refreshed.

I have bookmark created using this expression in the filter pane - =[Month Year]=Max({1} total [Month Year])

Re: Dynamic Default Bookmark with 'Always one selected value'

eero_h — Tue, 10 Aug 2021 09:30:57 GMT

Solution which works for me is to create a bookmark expression: =Only({1}Year) = Max({1}TOTAL Year). This way the expression ignores the selected Year value and picks the actual max Year. It is important to create the dynamic bookmark before changing the field setting to Always one selected value, otherwise the bookmark will evaluate the expression and bookmark will be static.

Re: Dynamic Default Bookmark with 'Always one selected value'

PärStjernberg — Mon, 03 Oct 2022 09:01:02 GMT

Tanks for the tip @eero_h. It works fine.

Re: Dynamic Default Bookmark with 'Always one selected value'

jda_bryan — Wed, 08 Mar 2023 18:57:14 GMT

Yes. This solution did the trick for me too. Fantastic suggestion. Thank you.

Re: Dynamic Default Bookmark with 'Always one selected value'

suganyaam — Fri, 14 Apr 2023 02:34:55 GMT

Did you check with "Apply Bookmark"? Cuz, i dint work for me

Re: Dynamic Default Bookmark with 'Always one selected value'

Rick_07011 — Thu, 09 Nov 2023 10:36:30 GMT

Thanks, It worked for me as well