topic Re: User Email display in the sheet in Management & Governance

User Email display in the sheet

Mangi — Wed, 29 Jan 2025 16:09:22 GMT

I am new to Qlik and i am testing for section access. In my sheet (for testing purposes), I want to display the email of the user who is looking at the sheet. Basically, i want to show the users email id (which is defined in section access) on a text&image object in the qlik sheet.

Re: User Email display in the sheet

BenjaminT — Fri, 26 Apr 2024 07:50:40 GMT

You can use the OSUser() function in an expression to get the current user's username, and then link back to a directory of all users to pick out their email.

https://community.qlik.com/t5/Design/Useful-System-Functions/ba-p/1476375

Re: User Email display in the sheet

mpc — Fri, 26 Apr 2024 07:52:08 GMT

Hi,

I guess you're using Qlik Cloud, then the function OSUser() will display the email ID of the user currently conected user, if you're using an IdP. To display the email, in your IdP configuration the sub section must be filled with "email" value, not "sub" value.

Kind regards