topic Fetching the Windows User in QlikView

Fetching the Windows User

Mon, 24 May 2010 11:56:47 GMT

Hi All

Does anyone know how I can identify the logged-in Windows user so that I can populate a variable? The application will be accessed from QV server using the IE Plug in. I have tried creating a SECTION ACCESS table with an NTNAME column and this will correctly pick up the Windows User, but the columns in this table are not available for me to query in the application.

I have also tried adding a SECTION APPLICATION table with 'Initial Selection based on Section Access' and this is initially correctly filtered for the user. I have then populated a variable during the Document OnOpen event but the scheduled reload of the document seems to change the variable to a diffeent user.

I suspect that I could use the Windows API to identify the Windows user, but I wanted to see if anyone know of a more natural QlikView option?

Thanks

Al.

Fetching the Windows User

Mon, 24 May 2010 12:08:32 GMT

Hi,

If i understood your question properly, QVUSER() function will help you to identify the logged in user in Qlikview.

-Peterson

Fetching the Windows User

Mon, 24 May 2010 12:21:55 GMT

Also, OSUser() will give you the fully qualified OS User name.

Regards,

Fetching the Windows User

Mon, 24 May 2010 12:24:52 GMT

Thanks. Not sure why my searches did not come up with that. OSUser() get the prize.

Thanks

Al.