Macro help - Preselect depending on domain user name

[#1]

Hi,

I have several users logging in through NTFS authorization.

Suppose they are Division Manager, and the requirement is that their responsible Division pre-selected once QV page open. (No reduction, they can still see everything once selection released).

How do I write a macro to distinguish the osuser name and preselect divisions for them, if I want to use the same application instead of generating several versions?

Thanks!

[#2]

You can use a variable which is filled with osuser() function. On Document open trigger you can select a value, based on the variable to the field division!

[#3]

Hi Jochem,

Thanks for reply, but I am not sure I understand what you meant.

I understand osuser() function but I don't know how to utilize that in your example.

Say the username is qlikview and he is assigned to Division B, how does that work in your method?

Thanks in advance!

[#4 · Accepted solution]

Maybe this can help you? In this example i did not use a variable for the osuser.

[#5]

Thanks Jochem, this is working!