topic Function to retrun the current windows user in QlikView

Function to retrun the current windows user

Fri, 31 Dec 2010 16:42:54 GMT

Hi all,

Is there a function in qlikview that returns the current windows user?

I'd like to base the visibility of some controlls on the windows user account.

Thx for any kind of hint.

Best Regards

Ludwig

Function to retrun the current windows user

hector — Fri, 31 Dec 2010 16:44:08 GMT

HI, use OSUSER()

rgds

Function to retrun the current windows user

Fri, 31 Dec 2010 17:21:14 GMT

Thx Hector.

I am trying to use the user account which I have now (Thx to you 🙂 to control the visibility of a couple buttons so the app displays buttons based on the user...I loaded a table that shows for each user which button should be on or off..structure below...

Botton1 Botton2 Botton3 Botton(n)

User 1 1 0 1 0

User 2 1 1 1 1

User3 1 0 1 0

How can I now link them up so everytime the app is opened each user only sees its assinged buttons..

Each hint much appr...

Thx

Function to retrun the current windows user

hector — Fri, 31 Dec 2010 17:35:17 GMT

Hi, i think the best way will be a table with this relationship between user and buttons

User | Button| Access
User1 | But01 | 1
User1 | But02 | 0

and so on....

Then, use the Initial Data Reduction Based on Section Access to only see the records for the current user and not all of them

And in the conditionality of the button, use something like Only(if(Button = 'But01',Access)), so it wll return true or false taking the value from the access table

Rgds & good luck

Function to retrun the current windows user

Fri, 31 Dec 2010 17:48:09 GMT

Great! Thx Hector for your input. Thx L. Will give a shot.