topic dynamic default filter according to the username in App Development

dynamic default filter according to the username

charlie2 — Tue, 01 Jun 2021 09:02:44 GMT

Hi,

I've got an App for the Sales Reps and I would like to set up a default filter that preselects the name of the sales rep when he/she opens the app.

I have a filter in the App called "Sales Reps Name" with the different names. Furthermore, I uploaded an excel table to the app, which matches the Sales Reps Name with their Username (field called 422Name) fromQlik, according to the formula OSUSER().

What I tried so far, without match success:

- In the filter "422Name", write the following formula: =422Name=Match(OSUSER()

- Set up this as a bookmark

However, the already first step doesn't work. Any help would be appreciated!

Thanks,

Re: dynamic default filter according to the username

MayilVahanan — Tue, 01 Jun 2021 10:01:26 GMT

Hi @charlie2

Try like below

Re: dynamic default filter according to the username

charlie2 — Tue, 01 Jun 2021 13:36:22 GMT

Hi @MayilVahanan ,

It worked at the end, with =user=SubField(OSUser(), '=',3) but I had to change the field name from 422Name to "user". I think because "422Name" starts with a number, it was not working...

Thanks anyways!