Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Security in Sheet Level

Dear QV Experts,

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


Please suggest me.


Thanks

1 Solution

Accepted Solutions
stigchel
Partner - Master
Partner - Master

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

or use a function that takes a seperated list

View solution in original post

8 Replies
stigchel
Partner - Master
Partner - Master

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

Re: Access only a particular sheet

Not applicable
Author

Thanks Piet,

How to add multiple users to access the particular sheet?

Thanks

stigchel
Partner - Master
Partner - Master

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
Master III
Master III

Try like

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

Not applicable
Author

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

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


Thanks

stigchel
Partner - Master
Partner - Master

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
Master III
Master III

Hi,

Is this not working for you?

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

Not applicable
Author

Thanks Settu. It is working. Thanks a lot.