Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

New Contributor

How to lookup a table on UI as expression


I have users table with Domain\UserName, Role loaded in memorry, When a user access the application through access point, the application should display his role on UI using his username who access the application on fly without using section access. Is it possible ?

Tags (1)
1 Reply

Re: How to lookup a table on UI as expression

You could use osuser() which will return the NTNAME of the user to identify them. To this you will need a mapping respectively a linked table to Role (and Domain\UserName if they are different to NTNAME). And Role could you display with an expression like:

only({< [Domain\UserName] = {"$(=osuser())"}>} Role)

- Marcus

Community Browser