dynamic default filter according to the username

[charlie2]

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,

[MayilVahanan]

Hi @charlie2 

Try like below

[charlie2 · Accepted solution]

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!