topic Macro help - Preselect depending on domain user name in QlikView

Macro help - Preselect depending on domain user name

Wed, 02 Mar 2011 15:55:56 GMT

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!

Macro help - Preselect depending on domain user name

Wed, 02 Mar 2011 16:09:28 GMT

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!

Macro help - Preselect depending on domain user name

Wed, 02 Mar 2011 16:25:06 GMT

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!

Macro help - Preselect depending on domain user name

Wed, 02 Mar 2011 16:34:13 GMT

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

Macro help - Preselect depending on domain user name

Wed, 02 Mar 2011 16:46:57 GMT

Thanks Jochem, this is working!