topic Display Logged in User Details in QlikView

Display Logged in User Details

Wed, 25 Nov 2020 16:16:04 GMT

Hi All

I need to display logged in user details (user name) in my dashboard.

Could you help me the entire flow, how can I do that.

Attached an example.

Thank you.

Re: Display Logged in User Details

pbk — Wed, 21 Sep 2016 01:27:05 GMT

You can add a text item to your sheet, and use one of the built-in system functions found here:

http://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/SystemFunctions/system-functions.htm

For example, osuser() or qvuser().

...pb

Re: Display Logged in User Details

jagan — Wed, 21 Sep 2016 02:48:54 GMT

Hi,

You can try OsUser() or QVUser() like below

= 'Logged in as ' & OSUser()

Hope this helps you.

Regards,

Jagan.

Re: Display Logged in User Details

Anil_Babu_Samineni — Wed, 21 Sep 2016 06:41:51 GMT

How do you provide the user and password

This is My Section Access Code

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD

ADMIN, Anil, Babu

USER, Anil123, Anil

];

Section Application;

If you want to provide from Inline then you can use = QVUser()

If you want to provide by NTName then you need to use = OSUSER()

This NTName, Coming from Local / Group then QVUser() and OSUSER() Will Work

Re: Display Logged in User Details

stabben23 — Wed, 21 Sep 2016 08:19:21 GMT

If Your OSUser is like 'DOMAIN\USER' then use this to filter the domainpart away from Your domain name

='Logged In as ' & upper(right(OSUser(),num(len(OSUser()) - Index(OSUser(), '\'))))

OSUser in normally not the real name so it could be hard to find.

Re: Display Logged in User Details

stabben23 — Wed, 21 Sep 2016 08:21:09 GMT

How about QVUser in QV12? is that function removed?

Re: Display Logged in User Details

Anonymous — Wed, 21 Sep 2016 08:27:24 GMT

Yes, It's not working in QV 12

Re: Display Logged in User Details

jagan — Wed, 21 Sep 2016 08:32:30 GMT

I think it will work when you have section access. If you don't have Then try OSUSER().

Check this description from Qlikview Help file.

OSuser( )

Returns a string containing the name of the current user as returned by the operating system.

QVuser( )

Returns a string containing the name of the current QlikView user as entered in a section access.

Regards,

Jagan.

Re: Display Logged in User Details

stabben23 — Wed, 21 Sep 2016 08:46:11 GMT

That is correct jagan‌, QVUser Works in section Access, but still the function wont get "blue", no big deal.

Re: Display Logged in User Details

Wed, 21 Sep 2016 17:41:18 GMT

Thank you.

Used QVUser() function instead of OSUser()

Re: Display Logged in User Details

jagan — Thu, 22 Sep 2016 05:25:20 GMT

Hi Narendra,

Please close this thread by giving Correct Answer to the post which helps you if you got the answer.

Regards,

Jagan.

Re: Display Logged in User Details

Tue, 29 Nov 2016 12:16:23 GMT

If your Domain-User is something like "UserDirectory=....domainName...;UserId=..PersonalID.." then you can use the following within the script to prepare for use in the worksheets:

SET vUserName = UPPER(OSUser());
SET vScriptUserName = Right( Right($(vUserName), Len($(vUserName)) - FindOneOf($(vUserName),';')), Len(Right($(vUserName), Len($(vUserName)) - FindOneOf($(vUserName),';'))) - FindOneOf(Right($(vUserName), Len($(vUserName)) - FindOneOf($(vUserName),';')),'=') );

Best regards