Discussion board where members can get started with QlikView.
I have a requirement where only the Managers have to login with their login credentials, to see all the employee data working under him and his own data in the dashboard.
Dept Manager Employee Emp credit
health A E 10
health A F 20
health A G 30
sports B A 10
sports B R 10
Finance D F 20
If Manager 'A' logs in he should see only employee data of E, F, G and his own data also , along with respective emp credit in the dashboard.
I have already segregated the data in an excel file, and using that in the section access code in the script.
The issue is, as you can see one Employee is having more than one Manager,
Employee F is having two managers => A and D.
If A logs in, only A should be present under Manager's field, as F is having two managers. I could see two Managers A and D in it.
How can i restrict data only to that manager. Am i missing something.?? or How should i segregate the data in section access
Help me in finding out
Creating Section Access purpose:
Go to Edit Script: File(menu)>Create Hidden Script<mention user name & password for Admin>
It will create new window (Hidden Script)
Insert> Section Access> Inline> Access Restriction Table Types> Basic NT Security(Select)
note: Basic NT Security-> it will creates security based on their login credentials
U can try this it will more than sufficient
Maybe create a canonical Manager/Employee field similar to what is shown with a date field here:
Then use this field as reduction field in SA.
See also this for potential other options
Authorization using a Hierarchy
Data Reduction Using Multiple Fields
Basics for complex authorization
can you explain how can i create a canonical Manager/Employee field with the data ?
Stafen wuhl given links plz refer go through links i dont it is very helpful easily understanding way.