Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
vikasmahajan

Unwanted qvw restrict to users from access control

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

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution.
If you want to go quickly, go alone. If you want to go far, go together.
1 Solution

Accepted Solutions
Gysbert_Wassenaar

See this discussion.


talk is cheap, supply exceeds demand

View solution in original post

3 Replies
Gysbert_Wassenaar

See this discussion.


talk is cheap, supply exceeds demand
khadeer
Specialist
Specialist

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

Not applicable

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