topic Select in field trigger using OSUser in QlikView

Select in field trigger using OSUser

samantha92 — Thu, 21 Jan 2016 11:08:21 GMT

Hi guys,

Having a slight problem here.

I want to be able to automatically select a manager from a list box when that said managers opens my report.

I have tried using macros but had no joy.

I have created a trigger 'On Open' and added this into my search string =OSUser() but I know it's not going to be as simple as this.

Anyone have any ideas on how I can automatically select the manager from my list box when they open the report using a trigger?

Thank you

Re: Select in field trigger using OSUser

sunny_talwar — Thu, 21 Jan 2016 17:42:46 GMT

=OSUser usually gives the Directory Name also and I have a feeling that your listbox for manager might include just the name. Trim =OSUser based on how the manager list box looks and then try to use that as the expression for On Open Trigger.

UPDATE: See if the attach works for you.

Re: Select in field trigger using OSUser

samantha92 — Fri, 22 Jan 2016 08:20:26 GMT

Hi Sunny,

I came up with this and this seems to do the trick:

=if(Lower(mid([Responsible Manager],(index([Responsible Manager],' ')+1))&left([Responsible Manager],1))=mid(OSUser(),(Index(OSUser(),'\')+1)),[Responsible Manager])

Thank you very much for your help!

Re: Select in field trigger using OSUser

sunny_talwar — Fri, 22 Jan 2016 11:12:05 GMT

Great