Function to retrun the current windows user

[#1]

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

[hector]

HI, use OSUSER()

rgds

[#3]

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

L

[hector]

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

[#5]

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