topic Multiple Level Section Access in QlikView

Multiple Level Section Access

Anonymous — Sat, 09 Aug 2014 10:45:04 GMT

Dear Experts,

I have some knowledge about section access,but this requirement needs expert's help.

I have two sets of data,the first one has only ADIDs of top management and they will not have any transactions associated.They want the complete access of my application.

Second data is the area where I need your help.Here we have Employee ID,ADID and Type.Here Employee ID will connect directly to my transactions for the reps.For specialists I have one more table through which I connect to my transactions.

Now the reps and specialists should access only their data(Transactions based on their Employee ID).

Could you please help with the logic.

Thanks & Regards

Jeba

Re: Multiple Level Section Access

evan_kurowski — Sat, 09 Aug 2014 13:59:06 GMT

Hello Jebamalai,

Not sure if anything looks off here. You seem to be using a unified security field (Emp ID) for all user roles. If fact data is marked with an (Emp ID) and you load ADID as NTNAME (as long as the entries are valid user accounts), you should be good to go.

Re: Multiple Level Section Access

ashfaq_haseeb — Sun, 10 Aug 2014 05:30:31 GMT

Hi,

Have a look at below post

http://community.qlik.com/blogs/qlikviewdesignblog/2014/06/02/data-reduction-using-multiple-fields

Regards

ASHFAQ