topic Re: Dynamic Bookmark not working with existing selections in App Development

Dynamic Bookmark not working with existing selections

Oliver_GER — Tue, 11 Jun 2024 11:13:48 GMT

Hi,

in the Datamodel I do have:

Data: load * inline [ Year 2023 2024 2025 ];

Then I filter for this

=Year=year(today())

After this I create a bookmark.

Now there are two scenarios

1) No filter is active and I apply the bookmark. ==> Result: 2024 is selected.

2) Filter is set to 2023 and I apply the bookmark ==> Result: Filter is removed, but 2024 is *not* selected.

Is there a workaround for this?

Re: Dynamic Bookmark not working with existing selections

marcus_sommer — Wed, 12 Jun 2024 11:40:10 GMT

You may try it with:

=year(today())

Re: Dynamic Bookmark not working with existing selections

lennart_mo — Wed, 12 Jun 2024 12:42:50 GMT

Using the following filter worked for me:

={1}Year=year(today())

Re: Dynamic Bookmark not working with existing selections

Oliver_GER — Wed, 12 Jun 2024 14:14:55 GMT

Thanks, that worked!

I had tried something very similar before, but it did not work out:

=Year=year({1}today())

Now I have to adapt this to our current real-world problem. It does work, but only if the field is not set to "always one selected". I can't reproduce this issue with the year example, so I guess I will be able to solve this.

Re: Dynamic Bookmark not working with existing selections

Oliver_GER — Wed, 12 Jun 2024 14:42:47 GMT

hi @lennart_mo - Unfortunately I am able to reproduce the issue with the basic setup:

Year: load * inline [ Year 2022 2023 2024 2025 ]; DefaultYear: load * inline [ User , DefaultYear A , 2022 yourOSUser , 2023 C , 2024 D , 2025 ];

Testing this expression:

only({<User = {$(=subfield(osuser(),'=',-1))} >} DefaultYear)

results in 2023 for my user. That is good.

Using this in a bookmark / filter works, but only as long as Year-field is *NOT* set to "allways one selected value.

={1}Year=only({1<User = {$(=subfield(osuser(),'=',-1))} >} DefaultYear)

Do you have any explanation, why this filter expressions works stops working once the field-setting is changed. And do you have any hint on how to solve this?

Re: Dynamic Bookmark not working with existing selections

lennart_mo — Thu, 13 Jun 2024 14:35:51 GMT

Hi @Oliver_GER,

I think you need to evaluate the search string because Qlik only uses actual search values when 'Always one selected value' is enabled, so it should work using something like this:

={1}Year=$(=Only({1<User = {$(=subfield(osuser(),'=',-1))} >} DefaultYear))

It's important that you create the bookmark before enabling 'Always one selected value', since doing so afterwards will only save the value itself and not the evaluated string.

Let me know if this worked for you as well!

Re: Dynamic Bookmark not working with existing selections

Oliver_GER — Wed, 26 Jun 2024 08:20:41 GMT

Hi @lennart_mo ,

sorry for the late reply.

I have used your Filter statement and stored it into a bookmark *before* enabling *allways one value selected. This is the statement stored in the bookmark:

{<Year={"={1}Year=$(=Only({1<User = {$(=subfield(osuser(),'=',-1))} >} DefaultYear))"}>}

The bookmark works great when "allways one value selected" is disabled and continues working once it was enabled.

I will now test this in my actual envirnoment to see if this actually solves the issue.

Update: In my Real-world scenario it was a string and not a number. Therefore I had to add chr(39):

={1}Language=$(=chr(39) & Only({1<User = {$(=subfield(osuser(),'=',-1))} >} DefaultLanguage) & chr(39))

This works for me! Thank you very, very much!