sheet level Security

[#1]

Hi All,

can i give Dashboard sheet level security to users ,if possible how to do

Thanks&Regards

pnreddy

[vivientexier]

you should use "section access".

[jagan]

Hi,

You can give sheet level security by using the

Sheet Properties -> General -> Show Sheet -> Select Condtional

and place your expression there.

Regards,

Jagan.

[saumyashah90]

Hi,

You can go to

Sheet Properties -> General ->Show Sheet ->Tick Conditional and write your expression.

for example if(ManagerName='XYZ',1,0);

[#5]

Could you please give me one example

thank you for your reply

[#6]

Could you please give me one example

thank you for your reply

[vikasmahajan]

PFA sample user login and password in data.xls

Vikas

[#8]

Hi

Sheet Properties -> General -> Show Sheet -> Select Condtional

give the expression like this

=manager='a' or manager='b'

if we select manager a or b then that sheet is disable otherwise it not disable

use the condition like this

[jagan]

Hi,

Check this thread in attached file.

Hope it helps you.

Regards,

Jagan.

[#10]

If you authenticate via Active Directory you can also use the OSUser() function in the conditional show box, e.g. OSUser() = 'domain\user'. Alternatively use QVUser() if QlikView handles the authentication

OSuser( )

Returns a string containing the name of the current user as returned by the operating system.

QVuser( )

Returns a string containing the name of the current QlikView user as entered in a section access.