Discussion Board for collaboration related to QlikView App Development.
We have 4 modules in access control using Qlikview Version 11 , User wise section access is implemented now we want to restrict users
to view documents which are not relevent to that user. Means if marketing user should not see Finanace Qvw in access control.
How to achive the same , Experts Please comments.
See this discussion.
View solution in original post
If you are using 4 different QVW's , you can restrict the data by giving section aceess in document level for different applications.
if you are did all modules in one application, you have to apply section access in data level. if any help needed in doing both i will help you.
Above post also very helpfull.
We use a Macro that runs OnOpen and gets the current user and compares it to the users we want to have access to a sheet. A variable is then set to either 1 or 0.
Then on the General Tab of the sheet properties in the Show Sheet Conditional box we put
"vShowSheet = 1" (which will show the sheet) otherwise it is hidden.
sub ShowSheetif (ActiveDocument.GetLayout.QVUser) = "User1" _or (ActiveDocument.GetLayout.QVUser) = "User2" then
set v = ActiveDocument.Variables("vShowSheet") v.SetContent "1", TrueElse set v = ActiveDocument.Variables("vShowSheet") v.SetContent "0", Trueend if
Hope this helps,