Display Logged in User Details

[#1]

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.

[pbk]

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]

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

[stabben23]

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]

How about QVUser in QV12? is that function removed?

[Anonymous]

Yes, It's not working in QV 12

[jagan]

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]

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

[#10]

Thank you.

Used QVUser() function instead of OSUser()