topic Re: Security in Sheet Level in QlikView

Security in Sheet Level

Thu, 21 Jan 2016 15:08:28 GMT

Dear QV Experts,

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

Please suggest me.

Thanks

stigchel — Thu, 21 Jan 2016 15:17:57 GMT

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

Thu, 21 Jan 2016 15:51:37 GMT

Thanks Piet,

How to add multiple users to access the particular sheet?

Thanks

stigchel — Thu, 21 Jan 2016 16:07:09 GMT

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 — Thu, 21 Jan 2016 16:10:52 GMT

Try like

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

Thu, 21 Jan 2016 16:21:54 GMT

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

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

Thanks

stigchel — Thu, 21 Jan 2016 16:29:42 GMT

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 — Thu, 21 Jan 2016 16:35:00 GMT

Hi,

Is this not working for you?

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

Thu, 21 Jan 2016 17:49:29 GMT

Thanks Settu. It is working. Thanks a lot.