Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
denis115
Creator
Creator

user/admin

Hello! I need to hide one sheet from one user but for other user and admin to show.

What I need to do?

7 Replies
Miguel_Angel_Baeyens

Right click on the background of the sheet > Properties > General > Show Sheet > Conditional and create an expression which fills that condition, like

If(USERNAME = 'ADMIN', 1, 0)

denis115
Creator
Creator
Author

THANKS!

denis115
Creator
Creator
Author

Im sorry but it doesnt work. admin is a username?

Bala_s
Contributor III
Contributor III

Update one more field like Flag, USER_ACCESS for Admin and one user and for other user which needs to be hide don't update Flag, and give condition as below:

if(USERNAME = 'ADMIN' or Flag = 'USER_ACCESS',1,0)

Peter_Cammaert
Partner - Champion III
Partner - Champion III

Not necessarily. This example just explains in general how you can show/hide sheets based on a condition. Your post doesn't contain enough information to take it any further.

What do you mean by 'user' and 'admin'? Roles? Groups? Usernames? Where do you get this characteristic? From the OS? From a table?

And finally how do you connect this characteristic to the current user, who will be identified most probably by way of an accountname. Qlikview can tell you the accountname of the current user through the system function OSUser().

See System Functions ‒ QlikView for more information on other system functions you can use to identify the current user.

denis115
Creator
Creator
Author

that's my example,can you take a look please, pass for my hidden script is  :  denis

denis115
Creator
Creator
Author

SECTION ACCESS I've used me how ADMIN and I can see all sheets,one more person can see fewer sheets and he is USER and the last person is also user but he must see the same pages like USER the difference between those two users consists in that the second user most not see the last page.

For example:

ADMIN,admin can see pages: sales,primsales,clients and region

USER,user1 can see pages : sales, primsales and clients

USER,user2,can see pages: sales and primesales

how can I do this?