Discussion Board for collaboration on QlikView Security and Governance.
i have qvw in these iam having sheet1 and sheet2 , and i want to provide these sheet2 access to particular users .
user details :
when user uses these userdetails to login then only sheet2 should be visible others should see all the sheet1 .
can any one help me on these .
Thanks In advance !
(ooxml, embedded labels, table is SA);
Then you add the sheet access coding directly underneath
LOAD USERS as NM,
(ooxml, embedded labels, table is SHEETS);
My Section Access table looks like you would expect and the NM column is to specify their role, MGR or NON for different sheet access, i.e.
NTNAME SAREP NM
him Richard NON
her Mike NON
mgr1 * MGR
mgr2 * MGR
and the Sheets Table looked like so:
USERS SH01 SH02 SH03.... SH07 SH08
NON 1 1 1 0 0
MGR 1 1 1 1 1
Then set the condition property for each respective sheet to show if the flag for that sheet is 1, i.e.:
Refer the below link:
QlikView Section Access Examples
it might be very helpful
suppose if you have sheet1 and sheet2 in your application.
you can apply section access like this...as fallows
In section access we must have to give some basic credentials these are
ACCESS-access type ntg but this user is admin or user
USER ID-user id is credential to user ntg but username
PASSWORD-we have to give the passwords for every users.
if you want to apply at sheet level..you have to add additional credentials like sheet names you have to add in
at sheet level credential you want to display that sheet to particular user you have to add 1 in that user.
you don't want to display that sheet to particular user you have to add 0.
LOAD * INLINE [
ACCESS, USERID, PASSWORD, SHEET1, SHEET2
ADMIN, ADMIN, 123, 1, 1
USER, USER1, 1234, 1, 0
USER, USER2, 1235, 0, 1
from this..admin will see the both the sheets
user1 will see the sheet1 only
user2 will see the only sheet2.
we have to create section access for this like below.
ACCESS, USERID, PASSWORD
ADMIN, ADMIN, ADMIN
USER, SA, SA
USER, TA, TA
Reload the QVW File and go to sheet Properties..
Show Sheet :
Conditional: here we have write like below.
CLOSE THE QVW File And login with TA. TA user Don't Have Access sheet 1 so its not visible.
Thanks for providing the detail information for the sheet level access very easy to understand .
but i have question here
I cant the information of the password from the user .
my changeling is when ever user use his Credentials as username based on that sheet should be visible .
for Eg: if user is logged with email@example.com then user should be able to his sheets .
Sry if my question not clear.
can you help me to solve this issue.
Thanks in advance !
you have to set the passwords as of you and your client understanding.
Your Requirement is ..
you have to show sheet2 information to only one particular user and remaining for all the users you don't want to show the sheet2 information right.
suppose if you want display sheet2 information to only user3 and remaining all the users can't see the sheet2 information,
and admin also can't see the sheet2 information when you are going to log in with admin credentials initially.
but after reloading the application in admin level .admin can access all the sheets information along with sheet2.
and normal users at any cost they didn't see the sheet2 information.
and user3 can only access the sheet2 information at any cost.
you can do like this:
ADMIN, ADMIN, 123, 1, 0
USER, USER2, 1235, 1, 0
I given the reply as of i understand your requirement,
this is not your final requirement,
share the what is your exact requirement,
have checked my post...