topic Re: Retrieve current user in QlikView

Retrieve current user

Tue, 11 Nov 2014 21:04:45 GMT

Hi all,

I have a configuration where users are logging in by using an accespoint. The users are managed in a custom directory.

In the dashboards I want to have the log in-name of the active user available. There is no section access implemented (I am using publisher for reduced documents). I have tried qvuser () and osuser (), but neither of them lead to required results.

Does anyone know of an alternative command or approach?

Thanks

Regards Remco

Re: Retrieve current user

jduenyas — Tue, 11 Nov 2014 23:46:41 GMT

In the VB Edit section enter this Macro

Public Function CurrentUser()

Set objNetWork = CreateObject("Wscript.Network")

CurrentUser = objNetwork.UserName

msgbox CurrentUser

End Function

You can then assign this value to a variable and use it throughout

Re: Retrieve current user

rwunderlich — Wed, 12 Nov 2014 00:08:13 GMT

qvuser () and osuser () should give you the correct results. Could you describe what output you are getting from those functions and what output you would like?

-Rob

Re: Retrieve current user

Wed, 12 Nov 2014 07:59:29 GMT

Hi Rob,

Thanks for your reply.

The strange thing is that both commands have no result: an empty string. What I want to see is the userID of the user that is using that application.

Regards Remco

Re: Retrieve current user

ashfaq_haseeb — Wed, 12 Nov 2014 08:08:08 GMT

Hi,

I personally tries this. It worked for me without any go with osuser()

osuser () Returns the custom user.

If not share a sample to check with.

Regards

ASHFAQ

Re: Retrieve current user

Wed, 12 Nov 2014 08:48:22 GMT

hey remco,

qvuser() will only work if section access has been applied. the osuser() should work.i tried it on my app and it worked.

maybe, if you could share your application and let everyone check.

cheers

kunal bhattacharjee

Re: Retrieve current user

Wed, 12 Nov 2014 12:47:06 GMT

Thanks all for your input. In the end OSUSER() [without typos.....] did the trick. This included the domain, but with some manipulation I created the string I wanted to have.

Cheers, Remco