Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
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 !
Section Access;
LOAD ACCESS,
NTNAME,
SAREP,
NM
FROM
'..\..\..\Dashboard\SectionAccess.xlsx'
(ooxml, embedded labels, table is SA);
Then you add the sheet access coding directly underneath
Section Application;
Sheet_Security:
LOAD USERS as NM,
SH01,
SH02,
SH03,
SH04,
SH05,
SH06,
SH07,
SH08
FROM
'..\..\..\Dashboard\SectionAccess.xlsx'
(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.:
SH08=1
Then reload!
Hi Mahesh,
Refer the below link:
QlikView Section Access Examples
it might be very helpful
Regards
Hemanth
Hi,
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.
and
if you want to apply at sheet level..you have to add additional credentials like sheet names you have to add in
section access.
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.
Section Access;
LOAD * INLINE [
ACCESS, USERID, PASSWORD, SHEET1, SHEET2
ADMIN, ADMIN, 123, 1, 1
USER, USER1, 1234, 1, 0
USER, USER2, 1235, 0, 1
];
Section Application;
from this..admin will see the both the sheets
user1 will see the sheet1 only
and
user2 will see the only sheet2.
Thanq.
Hi Mahesh,
we have to create section access for this like below.
Section Access;
LOAD * INLINE [
ACCESS, USERID, PASSWORD
ADMIN, ADMIN, ADMIN
USER, SA, SA
USER, TA, TA
];
Reload the QVW File and go to sheet Properties..
Genaral Tab:
Show Sheet :
Conditional: here we have write like below.
=QVUSER()='SA'
PRESS OK.
CLOSE THE QVW File And login with TA. TA user Don't Have Access sheet 1 so its not visible.
Regards
Sathish.
Hi Kalayani.
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 mahesh@polash.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 !
Regards
Mahesh.
Hi Mahesh,
you have to set the passwords as of you and your client understanding.
and
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:
Section Access;
LOAD * INLINE [
ACCESS, USERID, PASSWORD, SHEET1, SHEET2
ADMIN, ADMIN, 123, 1, 0
USER, USER1, 1234, 1, 0
USER, USER2, 1235, 1, 0
USER,USER3,1236,0,1
];
Section Application;
and
I given the reply as of i understand your requirement,
this is not your final requirement,
share the what is your exact requirement,
Thanq.
hi Mahesh,
have checked my post...
Regards
Sathish