topic Re: Permission to view sheet / Button in QlikView

Permission to view sheet / Button

Mon, 26 Jan 2026 18:19:17 GMT

Hi,

I've got a document where the users navigate between sheets through text boxes with actions,

I want that only certain users can view the textbox that move to sheet and sheet herself.

how can I do that?

Attaching example.

Thanks!

Re: Permission to view sheet / Button

Bill_Britt — Thu, 24 Jul 2014 11:40:14 GMT

Hi Jacob,

You could do this with section access. Not sure of other ways.

Bill

Re: Permission to view sheet / Button

alexandros17 — Thu, 24 Jul 2014 11:48:16 GMT

Hi,

a simple solution is with OsUser(), this function (try it in a text box) return the logged user.

You can enable the sheet navigation comparing OsUser() with a list of users enabled to perform the action.

Let me know

Re: Permission to view sheet / Button

stigchel — Thu, 24 Jul 2014 11:53:04 GMT

You can do this with section Access, something like this

//Table with users, NTNAME are their OS login ID's

//In ACCESGROUP you assign some value e.g. YES/NO to each user who can see sheet2

Section Access;

Load NTNAME, ACCESS, ACCESSGROUP

from users;

//link to your data

Section Application;

Load * inline [ACCESGROUP

YES

];

Then in the layout properties of your textbox/button put ACCESSGROUP='YES' in the conditional show

Re: Permission to view sheet / Button

Bill_Britt — Thu, 24 Jul 2014 11:57:29 GMT

Hi Alessandro,

Yes, this will work, but a smart user will find a way to bypass it. Section Access would be the best way.

Bill

Re: Permission to view sheet / Button

Thu, 24 Jul 2014 12:00:05 GMT

The post above by Piet Hein van der Stigchel will work, this is how i have implemented this kind of thing for clients.

Re: Permission to view sheet / Button

PradeepReddy — Thu, 24 Jul 2014 12:23:58 GMT

Please find the attached application.

User Access Info

ACCESS	USERID	PASSWORD	GROUP
ADMIN	admin	admin	*
USER	User1	User1	GROUP1
USER	User2	User2	GROUP2

Sheet access Info

GROUP	Report1	Report2
GROUP1	1	0
GROUP2	0	1

Hidden Script pwd : 123

In short,

User1 has accessto Only Report1

User2 has accessto Only Report2

Admin has access to all reports.

Regards,

Pradeep

Re: Permission to view sheet / Button

Bill_Britt — Thu, 24 Jul 2014 13:27:06 GMT

Hi Pradeep,

This is the way I would do it.

Bill