Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
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.
thanks
Vikas Mahajan
See this discussion.
Hi,
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.
Regards,
Khadeer
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 ShowSheet
if (ActiveDocument.GetLayout.QVUser) = "User1" _
or (ActiveDocument.GetLayout.QVUser) = "User2" then
set v = ActiveDocument.Variables("vShowSheet")
v.SetContent "1", True
Else
set v = ActiveDocument.Variables("vShowSheet")
v.SetContent "0", True
end if
end sub
Hope this helps,
Stephen