Skip to main content
Announcements
Qlik Community Office Hours - Bring your Ideation questions- May 15th, 11 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Security

Hi all,

What's the best way to go about restricting access to certain parts of QVW's? Particularly restricting access to certain tabs and then down into the sheet object level as well.

6 Replies
Anonymous
Not applicable
Author

For restricting actual data access, look at using Section access.

When restricting access to certain tabs or objects, combine the section access user with show/calculation conditions for these objects.

Not applicable
Author

Well I'm going to have a dashboard and want to restrict certain tabs to be seen by certain people.

Not applicable
Author

Do you or anyone else have an example .qvw with section access built in to show?

Jason_Michaelides
Luminary Alumni
Luminary Alumni

It's well explained in the reference manual.

pgalvezt
Specialist
Specialist

You have to create a Excel File and then load in qlikview Access like:

Section Access;
Star is *;

LOAD
ACCESS,
NTNAME,
SERIAL,
USERID,
PASSWORD,
IDUSUARIO

FROM Excel

WHERE ColumnExcel (Create for you) = 1; //Here 1 = Access; 0 = No Access

Section Application;

Star is *;

Sub:
LOAD
EMPR    As GL_EMPRESA,               // Section Access Field
@Empresa_Id
FROM Excel Column

User:
LOAD
IDUSUARIO,
NomUsuario
FROM Excel Column (Example = User)

Hope helps you

Jason_Michaelides
Luminary Alumni
Luminary Alumni

Always take a copy first as it is common to make a mistake and lock yourself out of your own document!