Security in Sheet Level

[#1]

Dear QV Experts,

Can we able add security at sheet level without using section access in QlikView?

Please suggest me.

Thanks

[stigchel]

You can use the OsUser() function in the conditional show of the sheet. See e.g.

Re: Access only a particular sheet

[#3]

Thanks Piet,

How to add multiple users to access the particular sheet?

Thanks

[stigchel]

If there are say two, a simple or could do that

=OSUser()='Domain\User' or OSUser()='Domain\User'

If there are more you could check against a concatenated string of users

Match(OsUser(), Concatenated string)>0

or load a data island with User and e.g. a field AccessGroup and something like (this needs some quotes '' around fieldnames, pls check help)

FieldValue(AccessGroup,FieldIndex(User, OsUser()))='AccessSheet1'

[settu_periasamy]

Try like

Mixmatch(Osuser(),'User1','User2','User3')

[#6]

Can we separate by “;” or a “,”  also like this below,

OSUser()='Domain\User' ;'Domain\User'

Thanks

[stigchel · Accepted solution]

No, that's not possible. Either use an or repeating the OsUser()= or OsUser()=

or use a function that takes a seperated list

[settu_periasamy]

Hi,

Is this not working for you?

Mixmatch(Osuser(),'Domain\User1','Domain\User2','Domain\User3')

[#9]

Thanks Settu. It is working. Thanks a lot.