topic Re: Bookmarks in App Development

Bookmarks, Is it possible to set a specific bookmark as default depending on the user?

SonPhan — Thu, 13 Oct 2022 19:56:52 GMT

Hello Qlik Experts,

Is it possible to set a specific bookmark as default depending on the user?

Means e.g. User A has the default bookmark Germany and User B has the default bookmark Austria.

Best regards Son

vinieme12 — Fri, 06 May 2022 19:14:23 GMT

Yes you can,

Filter the Country field using an expression search as below

=Country =Pick(wildmatch(OSUser(),'*userA','*UserB','*yourID'),'Germany','Austria','*')

press enter to apply the filter
Create the bookmark now and set it as default
Save the App
This bookmark will apply filter based on the expression search based on the userid

SonPhan — Fri, 06 May 2022 23:13:22 GMT

Thank you this helps me!

Have you any idea how to solve it for multiple Country?

In regular expression, this works!

But when you set it to a variable (with your logic) it doesnt recognize the filters.

Best regards Son

vinieme12 — Sat, 07 May 2022 13:26:25 GMT

I would ideally do it as below

Create an Island Table in your data model which has information about the User & Filter value as below for example

UserFilters:

Load * Inline [

User,CountryFilter

UserA,AT

UserB,DE

UserC,AT

UserC,DE

];

Create Two Variables

vUser : =subfield(OSUser(),'UserId=',2) //with the starting EQUAL sign

vDefaultFilter: =concat({<User={"$(vUser)"}>}Distinct chr(39)&CountryFilter&chr(39),',') //with the starting EQUAL sign

Then in the Country field apply filter as below

=Match(Country,$(vDefaultFilter))

press enter to apply the filter
Create the bookmark now and set it as default
Save the App
This bookmark will apply filter based on the expression search based on the UserID returned from OsUser() and match it with the associated values in CountryFilter field

SonPhan — Mon, 09 May 2022 06:43:46 GMT

Hello,

this works thank you!