topic How to control the access on the sheet level in QlikView

How to control the access on the sheet level

Mon, 14 Feb 2011 04:10:46 GMT

Hi,

Can we control the access on the sheet level?

For example:

A could access Sheet1 and B could access Sheet2.

Is it possible?

Thanks.

How to control the access on the sheet level

vgutkovsky — Mon, 14 Feb 2011 04:31:00 GMT

Yes, this is possible. You can use Section Access to reduce a flag value and then hide the sheet based on the max value. For example:

Section Access;

LOAD * INLINE [
ACCESS,USERID,PASSWORD,FIELDA
USER,USERA,1234,1
USER,USERB,4567,2
];

Then you can hide the sheet by using the fieldindex() function (see Help for more details). Alternatively, you can set a variable by using the QVUSER() function and use nested IFs. You would still need section access to get the user to logon (or use the OSUSER() function if that's acceptable). Then the sheet would be hidden based on the variable. I personally prefer this 2nd solution because it is more straightforward.

Regards,

How to control the access on the sheet level

Mon, 14 Feb 2011 04:48:18 GMT

S ,it is possible using section Access,

find the attached appln.

user id for login :1,2,3

How to control the access on the sheet level

Mon, 14 Feb 2011 05:35:32 GMT

Hi,

Could you paste the code directly? Thanks.

How to control the access on the sheet level

Mon, 14 Feb 2011 05:46:22 GMT

Section

Access;

Section Access;

LOAD * INLINE [
USERID, ACCESS
1, user
2,user
3,admin
];

section application;

Load * INLINE [
USERID,SHEETID
1,SH01
2,SH02
3,SH01
3,SH02
]

How to control the access on the sheet level

Mon, 14 Feb 2011 05:53:41 GMT

Thanks,

But how to control userid just could see the SH01?

How to write the control visibility of the SH01 by expression?

Thanks.

How to control the access on the sheet level

Mon, 14 Feb 2011 08:21:29 GMT

I use the code you provided, USERID still could sheet2(SH02), is there anything else I need to config?

Thanks.

How to control the access on the sheet level

Mon, 14 Feb 2011 13:52:58 GMT

=Sum(if(SHEETID='SH01',1,0))>=1

=Sum(if(SHEETID='SH02',1,0))>=1

and In Settings--Document Properties--Opening check the Initial Data reduction based on section Access

How to control the access on the sheet level

Mon, 14 Feb 2011 14:35:52 GMT

Many thanks, and another question, why do you put great than(>) sign into this expression? I think this expression is also equal to 1 if some one has access.

Could you help me out?

How to control the access on the sheet level

Wed, 16 Feb 2011 07:51:58 GMT

s,it will work

Re: How to control the access on the sheet level

sreeni_qvd — Fri, 06 Dec 2013 04:32:30 GMT

It's working fine,

Re: How to control the access on the sheet level

sreeni_qvd — Fri, 06 Dec 2013 05:18:28 GMT

Hi Bhaskar Reddy,

It's working fine,

can you please explain below condition. how it is working briefly.

what is the meaning "1" and "0" and >=1

=Sum(if(SHEETID='SH01',1,0))>=1