Qlik Community

QlikView Security & Governance

Discussion Board for collaboration on QlikView Security and Governance.

Not applicable

Permission to view sheet / Button

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!

1 Solution

Accepted Solutions
stigchel
Honored Contributor

Re: Permission to view sheet / Button

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

NO

];

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

7 Replies
Employee
Employee

Re: Permission to view sheet / Button

Hi Jacob,

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

Bill

Re: Permission to view sheet / Button

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

stigchel
Honored Contributor

Re: Permission to view sheet / Button

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

NO

];

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

Employee
Employee

Re: Permission to view sheet / Button

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

Not applicable

Re: Permission to view sheet / Button

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

pradeepreddy
Valued Contributor II

Re: Permission to view sheet / Button

Please find the attached application.

User Access Info

ACCESSUSERIDPASSWORDGROUP
ADMINadminadmin*
USERUser1User1GROUP1
USERUser2User2GROUP2

Sheet access Info

GROUPReport1Report2
GROUP110
GROUP201

Hidden Script pwd : 123

In short,

User1 has accessto Only Report1

User2 has accessto Only Report2

Admin has access to all reports.

Regards,

Pradeep

Employee
Employee

Re: Permission to view sheet / Button

Hi Pradeep,

This is the way I would do it.

Bill

Community Browser