topic Re: user/admin in QlikView

user/admin

denis115 — Wed, 25 Nov 2020 16:16:04 GMT

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

What I need to do?

Re: user/admin

Miguel_Angel_Baeyens — Wed, 30 Aug 2017 11:18:58 GMT

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)

Re: user/admin

denis115 — Wed, 30 Aug 2017 11:31:45 GMT

THANKS!

Re: user/admin

denis115 — Wed, 30 Aug 2017 11:56:31 GMT

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

Re: user/admin

Bala_s — Wed, 30 Aug 2017 12:12:19 GMT

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)

Re: user/admin

Peter_Cammaert — Wed, 30 Aug 2017 12:23:54 GMT

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.

Re: user/admin

denis115 — Wed, 30 Aug 2017 12:36:16 GMT

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

Re: user/admin

denis115 — Wed, 30 Aug 2017 13:19:09 GMT

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?