topic Re: Unwanted qvw restrict to users from access control in QlikView

Unwanted qvw restrict to users from access control

vikasmahajan — Mon, 17 Jun 2013 13:01:30 GMT

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

Re: Unwanted qvw restrict to users from access control

Gysbert_Wassenaar — Mon, 17 Jun 2013 16:24:54 GMT

See this discussion.

Re: Unwanted qvw restrict to users from access control

khadeer — Mon, 17 Jun 2013 17:42:56 GMT

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

Re: Unwanted qvw restrict to users from access control

Mon, 17 Jun 2013 22:48:13 GMT

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