topic Re: sheet Level access in QlikView

sheet Level access

Anonymous — Mon, 26 Jan 2026 18:19:17 GMT

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 :

uday.kumar@outlook.com

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 !

Re: sheet Level access

vardhancse — Wed, 07 Dec 2016 05:14:41 GMT

Section Access;

LOAD ACCESS,

NTNAME,

SAREP,

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!

Re: sheet Level access

hemanthaanichet — Wed, 07 Dec 2016 05:49:09 GMT

Hi Mahesh,

Refer the below link:

QlikView Section Access Examples

it might be very helpful

Regards

Hemanth

Re: sheet Level access

Anonymous — Wed, 07 Dec 2016 06:28:56 GMT

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.

Re: sheet Level access

satheshreddy — Wed, 07 Dec 2016 06:38:37 GMT

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.

Re: sheet Level access

Anonymous — Wed, 07 Dec 2016 07:15:09 GMT

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.

Re: sheet Level access

Anonymous — Wed, 07 Dec 2016 07:50:52 GMT

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.

Re: sheet Level access

satheshreddy — Thu, 15 Dec 2016 13:50:11 GMT

hi Mahesh,

have checked my post...

Regards

Sathish