topic Re: through Section access give the permission to multiple sheets in QlikView

through Section access give the permission to multiple sheets

sreeni_qvd — Thu, 23 Apr 2015 08:54:11 GMT

Hi All,

I have 4 sheets. and 5 users 1. ADMIN, 2. USER1, 3.USER2, 4. USER3, 5. USER4

1. ADMIN can access to see the all sheets

2. User1 can access to the only sheet1, sheet2

3. User2 can access to the only sheet2, sheet3

4. User3 can access to the only sheet1, sheet4

5, user4 can access to the only sheet1.

Please help any one how to resolve this problem.

Regards:

Sreeni

Re: through Section access give the permission to multiple sheets

Anonymous — Thu, 23 Apr 2015 09:35:10 GMT

Hi Sreeni

refer below link

Section Access - Hide Sheet Level

Thanks

BKC

Re: through Section access give the permission to multiple sheets

buzzy996 — Thu, 23 Apr 2015 09:43:47 GMT

use this way,

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];

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

Re: through Section access give the permission to multiple sheets

Anonymous — Thu, 23 Apr 2015 09:45:54 GMT

Re: HOW TO RESTRICT SHEET ACCESS WITH SECTION ACCESS

Re: through Section access give the permission to multiple sheets

sreeni_qvd — Thu, 23 Apr 2015 10:23:17 GMT

Hi Balkumarchandel Chandel,

thanks for responding my post,

Can you please give the which condition can i mention for each sheet* ,*

*send me the expression on conditional for each sheet. *

Regards:

Sreeni

On Thu, Apr 23, 2015 at 3:16 PM, balkumarchandel chandel <

Re: through Section access give the permission to multiple sheets

buzzy996 — Thu, 23 Apr 2015 10:54:59 GMT

with my above example u have to do on each sheet level,

On Main sheeet : sheet properties--General---Show sheet---Conditional here Main='1'

On Sheet1 sheeet : sheet properties--General---Show sheet---Conditional here Sheet1 ='1'

On Sheet2 sheeet : sheet properties--General---Show sheet---Conditional here Sheet2 ='2'

On Sheet3 sheeet : sheet properties--General---Show sheet---Conditional here Sheet3 ='3'

On Sheet4 sheeet : sheet properties--General---Show sheet---Conditional here Sheet4 ='4'

and don't forget to select,from doucment properties--opening tab

1. Initial data reduction and strictly exclusion