topic Re: Security in QlikView

Security

Tue, 10 Jul 2012 20:25:57 GMT

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.

Re: Security

Anonymous — Wed, 11 Jul 2012 03:39:58 GMT

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.

Re: Security

Wed, 11 Jul 2012 19:47:43 GMT

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

Re: Security

Wed, 11 Jul 2012 20:10:38 GMT

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

Re: Security

Jason_Michaelides — Wed, 11 Jul 2012 21:15:59 GMT

It's well explained in the reference manual.

Re: Security

pgalvezt — Wed, 11 Jul 2012 21:24:20 GMT

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

Re: Security

Jason_Michaelides — Wed, 11 Jul 2012 22:11:09 GMT

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