Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Read about Qlik’s Response to COVID-19 Read the Letter, Join the Group.
Contributor III

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
Highlighted
Contributor

Re: Section Access Issue

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 

Highlighted
MVP
MVP

Re: Section Access Issue

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

Highlighted
Contributor III

Re: Section Access Issue

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

Highlighted
Contributor

Re: Section Access Issue

Hi Kishore,

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