Discussion Board for collaboration on QlikView Security and Governance.
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?
Go to Solution.
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
Load NTNAME, ACCESS, ACCESSGROUP
//link to your data
Load * inline [ACCESGROUP
Then in the layout properties of your textbox/button put ACCESSGROUP='YES' in the conditional show
You could do this with section access. Not sure of other ways.
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
Yes, this will work, but a smart user will find a way to bypass it. Section Access would be the best way.
The post above by Piet Hein van der Stigchel will work, this is how i have implemented this kind of thing for clients.
Please find the attached application.
User Access Info
Sheet access Info
Hidden Script pwd : 123
User1 has accessto Only Report1
User2 has accessto Only Report2
Admin has access to all reports.
This is the way I would do it.