Dynamic Bookmark Not Working in Qlik Cloud

[SamTaubman]

Hi, I am on Qlik Cloud and am having trouble getting a dynamic bookmark to work. I have a field [Display Currency] which has EUR and USD values and I would like to set a dynamic bookmark to select a value based on the User accessing the Qlik Cloud App.

I have an inline table that loads User_ID's with their TargetCurrency. I created two variables:

vCleanUser: =Trim(SubField(OSUser(), '=', -1))

vDefaultCurrency: =Only({<User_ID={"$(vCleanUser)"}>} TargetCurrency)

These return the expected values of my user and the respective currency. In this case it is EUR.
I've tried many combinations of searches in the [Display Currency] search bar but nothing works, it either returns EUR and USD or it returns nothing.
Here are some examples:
=Match([Display Currency], $(vDefaultCurrency))
=[Display Currency] = vDefaultCurrency
=Display Currency = Only({1} vDefaultCurrency)
=Display Currency = Only({1} $(vDefaultCurrency))
=vDefaultCurrency
=$(vDefaultCurrency)
=$(=$(vDefaultCurrency))
=("$(vDefaultCurrency)")

How can I get this to work?

I used this post as a guide: https://community.qlik.com/t5/App-Development/Bookmarks-Is-it-possible-to-set-a-specific-bookmark-as...

[robert_mika]

I think the example (link)you provided use Pick/match,

Search filtering is very 'picky', Did you try to set up in the way as in example/.

[SamTaubman · Accepted solution]

Thanks for the tip Robert_mika. I managed to get this to work. It seems like dynamic bookmarks do not work on fields with a space in the name. I had to change the [Display Currency] field to DisplayCurrency and then I was able to get it working like this:

vCleanUser: =subfield(OSUser(),'UserId=',2)

vDefaultCurrency: =concat({<User_ID={"$(vCleanUser)"}>}Distinct chr(39)&TargetCurrency&chr(39),',')

Search: =Match(DisplayCurrency,$(vDefaultCurrency))