topic Re: Section Acces in QlikView

Section Acces

Mon, 02 Feb 2015 06:50:46 GMT

Hi,

I have a hierarchy of Groups and divisions. one group has many divisions. i want to restrict user at group level and don't want to let user see the divisions.

suppose if i have 3 groups the user should be able to see only group aggregated data. he should not be able to see drill down data of divisions. please help.

Regards,

Piyush

Re: Section Acces

avinashelite — Mon, 02 Feb 2015 06:57:17 GMT

Hi Piyush,

Please see the attachment for the solution :

please see the excess file attached for the scenario's and use the userid as 1,2,3,4

Re: Section Acces

Mon, 02 Feb 2015 07:07:41 GMT

Thanks Avinash,

i am looking into it. Thanks for help.

Piyush

Re: Section Acces

avinashelite — Mon, 02 Feb 2015 07:09:32 GMT

np, Hope it helps you

Re: Section Acces

Mon, 02 Feb 2015 07:09:57 GMT

The file is locked. can you share the password.

Re: Section Acces

avinashelite — Mon, 02 Feb 2015 07:12:53 GMT

It does not require password. Use the USERID as

5 it will work.

Re: Section Acces

Mon, 02 Feb 2015 07:14:58 GMT

well. i know the steps you have shared. if there is next level ....suppose under supervisor id there are several employees and i don't want to see the employees. just want to restrict user at supervisor level. because when i leave employees column blank in script, it automatically provide user to look into employee data.

Re: Section Acces

avinashelite — Mon, 02 Feb 2015 07:19:40 GMT

You can implement the section access without hierarchy then only the logged in user related data will get displayed related data will get displayed.

read only the supervisor ID from the DB and provide them the access

Re: Section Acces

Mon, 02 Feb 2015 07:19:56 GMT

what is the concept of ancestor id and without section access script who this is working...can u please explain this.

Piyush

Re: Section Acces

avinashelite — Mon, 02 Feb 2015 07:26:46 GMT

AncestorID is nothing but the supervisor id of that employee, I am using this AncestorID to give access for the supervisor to view the details of his subordinates.

eg:

USERID,Name,Supervisor_id

1,A,0

2,B,1

3,C,2

4,D,2

5,E,1

];

1 is the supervisor of B(2),E(5) and 2(B) is the supervisor of C and D

so B has access to see C and D 's data.

Since A is the supervisor of B he has access to see B and his Subordinates data also

Re: Section Acces

avinashelite — Mon, 02 Feb 2015 07:38:51 GMT

if you have got the answer please close this thread