Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Section Access Issue

Hi all,

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.

Example:

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, 

Example:

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

Thanks you..

4 Replies
ravikumar_iyana
Creator
Creator

Hi Kishore,

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    

Example:

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

U can try this it will more than sufficient 

swuehl
MVP
MVP

Maybe create a canonical Manager/Employee field similar to what is shown with a date field here:

Canonical Date

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

Anonymous
Not applicable
Author

can you explain how can i create a canonical Manager/Employee field with the data ?

ravikumar_iyana
Creator
Creator

Hi Kishore,

Stafen wuhl given links plz refer go through links i dont it is very helpful easily understanding way.