Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello! I need to hide one sheet from one user but for other user and admin to show.
What I need to do?
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)
THANKS!
Im sorry but it doesnt work. admin is a username?
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)
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.
that's my example,can you take a look please, pass for my hidden script is : denis
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?