Unwanted qvw restrict to users from access control

[vikasmahajan]

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

[Gysbert_Wassenaar · Accepted solution]

See this discussion.

[khadeer]

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

[#4]

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