topic Re: Re: sheet level Security in QlikView

sheet level Security

Fri, 25 Oct 2013 05:33:24 GMT

Hi All,

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

Thanks&Regards

pnreddy

Re: sheet level Security

vivientexier — Fri, 25 Oct 2013 05:41:40 GMT

you should use "section access".

Re: sheet level Security

jagan — Fri, 25 Oct 2013 05:43:18 GMT

Hi,

You can give sheet level security by using the

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

and place your expression there.

Regards,

Jagan.

Re: sheet level Security

saumyashah90 — Fri, 25 Oct 2013 05:48:02 GMT

Hi,

You can go to

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

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

Re: sheet level Security

Fri, 25 Oct 2013 06:39:46 GMT

Could you please give me one example

thank you for your reply

Re: sheet level Security

Fri, 25 Oct 2013 06:40:38 GMT

Could you please give me one example

thank you for your reply

Re: Re: sheet level Security

vikasmahajan — Fri, 25 Oct 2013 06:47:06 GMT

PFA sample user login and password in data.xls

Vikas

Re: sheet level Security

Fri, 25 Oct 2013 06:49:54 GMT

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

Re: Re: sheet level Security

jagan — Fri, 25 Oct 2013 06:52:52 GMT

Hi,

Check this thread in attached file.

Hope it helps you.

Regards,

Jagan.

Re: sheet level Security

Fri, 25 Oct 2013 06:59:25 GMT

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.

Re: sheet level Security

Thu, 28 Nov 2013 11:25:08 GMT

Hi PN Reddy

PFA.