Qlikview Sheet Level Security?

[#1]

Hi,

I Have Qv Dashboard using around 200 users

Sheets before

A,B,C

recently we created new sheet D

A,B,C,D

for that new sheet we have to implement Security

for 100 users we have to show all the sheets(A,B,C,D)

remaining 100 users (A,B,C)

Please help

Thanks

[avinashelite]

You need to make use of section access to achieve this , check this

Sheet level access

Section Access in sheet level

Sheet Level Security - Conditional Show

[Anonymous]

Just a simple idea (length of login name within domain must be identical😞

You need to create an access table somewhere.

ACCESS:
LOAD * inline [
GroupABC,  GroupABCD
yourdomain\user1 , yourdomain\user2
yourdomain\user3 , yourdomain\user4
] ;

Then go to the properties page of each sheet:

For sheets A, B and C set the following condition:

=wildmatch(Upper(Concat(GroupABC)),'*'&Upper(OSUser())&'*')

For sheet D set:

=wildmatch(Upper(Concat(GroupABC)),'*'&Upper(OSUser())&'*')
or wildmatch(Upper(Concat(GroupABCD)),'*'&Upper(OSUser())&'*')

That's all. Using the Upper function ist optional.