Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear QV Experts,
Can we able add security at sheet level without using section access in QlikView?
Please suggest me.
Thanks
No, that's not possible. Either use an or repeating the OsUser()= or OsUser()=
or use a function that takes a seperated list
You can use the OsUser() function in the conditional show of the sheet. See e.g.
Thanks Piet,
How to add multiple users to access the particular sheet?
Thanks
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'
Try like
Mixmatch(Osuser(),'User1','User2','User3')
Can we separate by “;” or a “,” also like this below,
OSUser()='Domain\User' ;'Domain\User'
Thanks
No, that's not possible. Either use an or repeating the OsUser()= or OsUser()=
or use a function that takes a seperated list
Hi,
Is this not working for you?
Mixmatch(Osuser(),'Domain\User1','Domain\User2','Domain\User3')
Thanks Settu. It is working. Thanks a lot.