How to get First name in Welcome note ??

[Theshantanu]

Hello,

I am trying to customize a welcome note in my dashboard. But, when I use OSUSER() I get an ID, is it possible to get first name of the user.

I have a excel sheet which has all IDs and their names, which I can upload separately.

Please advise, Thanks!

[vikasmahajan]

Hi,

You can achieve this using firstsortedvalue :

https://help.qlik.com/en-US/sense/February2023/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/Basic....

Examples and results

Example	Result
firstsortedvalue (Product, UnitPrice)	BB, which is the Productwith the lowest UnitPrice(9).
firstsortedvalue (Product, UnitPrice, 2)	BB, which is the Productwith the second-lowest UnitPrice(10).
firstsortedvalue (Customer, -UnitPrice, 2)	Betacab, which is the Customerwith the Product that has second-highest UnitPrice(20).
firstsortedvalue (Customer, UnitPrice, 3)	NULL, because there are two values of Customer (Astrida and Canutility) with the samerank (third-lowest) UnitPrice(15). Use the distinct qualifier to make sure unexpected null results do not occur.
firstsortedvalue (Customer, -UnitPrice*UnitSales, 2)	Canutility, which is the Customer with the second-highest sales order value UnitPrice multiplied by UnitSales (120).

regards

Vikas

[rwunderlich · Accepted solution]

Assuming the fields in your excel sheet are "ID" and "Name".

='Welcome ' & only({<ID={'$(=OSUser())'}>}Name)

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com