Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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!
Hi @charlie2
Try like below
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!