Discussion Board for collaboration related to QlikView Deployment.
I dont want one of my user to access certain sheets in my qvw file. I used section access for different user, but i dont know how to hide sheets for different user.
When a user logs in using userid and pwd, some sheets should be hidden.
Hope this will help you.
Thanks & Regards
Thank you upendra
I am unable to unrar your file.
You could create a field in your users table, something like ShowTabs. Everyone would have a 1 there, except the user in question.
Since your Security Table will not be available after Section Access is used, I would reload the contents of your Security table into another table and Qualify it.
SecurityTable:Load ...Qualify *;AccessTable:Load * Resident SecurityTable;Unqualify *;
Load * Resident SecurityTable;
Then on your charts Conditional Show, use: AccessTable.ShowTabs = 1.
Thanks! This is helpful!
an example in my attachment here
Re: How to hide sheet from users?
Use this code in script where 1 show page and 0 hide page
REPLACE LOAD * INLINE [
USER, PAGE01, PAGE02, PAGE03, PAGE04
XXXXX, 1, 1, 1, 1
USERID, 1, 1, 1, 0
Check this too.
Sheet level access