Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
Well I'm going to have a dashboard and want to restrict certain tabs to be seen by certain people.
Do you or anyone else have an example .qvw with section access built in to show?
It's well explained in the reference manual.
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
Always take a copy first as it is common to make a mistake and lock yourself out of your own document!