Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Display Logged in User Details

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.

11 Replies
pbk
Employee
Employee

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-...

For example, osuser() or qvuser().

...pb

jagan
Luminary Alumni
Luminary Alumni

Hi,

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

= 'Logged in as  ' & OSUser()

Hope this helps you.

Regards,

Jagan.

Anil_Babu_Samineni

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
stabben23
Partner - Master
Partner - Master

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.

stabben23
Partner - Master
Partner - Master

How about QVUser in QV12? is that function removed?

Anonymous
Not applicable
Author

Yes, It's not working in QV 12

jagan
Luminary Alumni
Luminary Alumni

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.

stabben23
Partner - Master
Partner - Master

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

Not applicable
Author

Thank you.

Used QVUser() function instead of OSUser()