Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
charlie2
Contributor III
Contributor III

dynamic default filter according to the username

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,

1 Solution

Accepted Solutions
charlie2
Contributor III
Contributor III
Author

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!

View solution in original post

2 Replies
MayilVahanan

Hi @charlie2 

Try like below

MayilVahanan_0-1622541676762.png

 

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
charlie2
Contributor III
Contributor III
Author

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!