topic Re: Single Application with Multiple configurations in QlikView

Single Application with Multiple configurations

hobanwashburne — Tue, 23 Jun 2015 13:33:16 GMT

I have a sales analysis application that is used by people in a variety of roles such as Regional Managers, Branch Managers, and Industry Specialists. I would like to build one application and selectively hide/show the relevant sheets. For example:

Configuration 1
Name: Admin
Description: All sheets shown
Reduce by Field: None

Configuration 2
Name: Regional Manager
Description: Sheets 1, 2, 3, 5, 7 shown
Reduce by Field: Region Name

Configuration 3
Name: Branch Manager
Description: Sheets 1, 2, 7 shown
Reduce by Field: Branch Name

Configuration 4
Name: Industry Specialists
Description: Sheets 1, 2, 5, 7 shown
Reduce by Field: Industry Name

Does anyone know of an example similar to this?

Re: Single Application with Multiple configurations

florentina_doga — Tue, 23 Jun 2015 13:45:32 GMT

use section access

Re: Single Application with Multiple configurations

maxgro — Tue, 23 Jun 2015 13:52:04 GMT

I think you have to mix

sheet level access

Sheet level access

and for multiple fields authorization

Data Reduction Using Multiple Fields

Re: Single Application with Multiple configurations

swuehl — Tue, 23 Jun 2015 13:55:18 GMT

You can have a look into

Data Reduction – Yes, but How?

following also the discussion about pros / cons of object based security (i.e. show / hide conditions) and referenced documents on section access.

If you absolutely want to hide sheets, you can create an appropriate show condition in sheet properties.

Re: Single Application with Multiple configurations

buzzy996 — Tue, 23 Jun 2015 14:14:51 GMT

implementing section access is the solution for this.

some thing like below,

User Based Access (Sheet level):

Section Access;
Load * Inline
[ACCESS,USERID,PASSWORD
ADMIN,A,X
USER,U1,Y1
USER,U2,Y2
USER,U3,Y3
USER,U4,Y4
USER,U5,Y5];

Section Application;
Load * Inline [
USERID,Main,Sheet1,Sheet2
A,1,1,1
U1,0,1,1
U2,0,1,0
U3,0,0,1
U4,1,1,1
U5,1,1,0
];

Re: Single Application with Multiple configurations

florentina_doga — Tue, 23 Jun 2015 14:22:29 GMT

please enter with user aa and password aa1

user bb and password bb1

user admin and password admin1