Authorization in qlikview

[deepakqlikview_123]

Hello Expert,

Can you please help me how to perform authorization in qlikview.

Below  is my requirement.

Authorization:

Case: There is one All India Head  Mr. Ram who can view the Records
at All India Level (North, South, East and West)

4 Regional Managers reporting to him can see data for their respective
Region.

1. Amità Regional Manager for East
2. Sumità Regional Manager for West
3. Suhasà Regional Manager for North
4. Nitinà Regional Manager for South

Can you please help us out how toachieve end result in this.

Thanks,

[deepakqlikview_123]

Please find below code for section access.

It is working fine as it is.

Section Access;


LOAD * INLINE



[

ACCESS, USERID, PASSWORD



ADMIN, ADMIN, ADMIN123



USER, HEAD,HEAD123

USER, A, USER123

];

Section Application;




LOAD * INLINE



[

USERID, Region



ADMIN,North

ADMIN,South

ADMIN,East

ADMIN,West

HEAD,North

A,South

];

But as per requirement I need to put all my user id pw and corresponding regions(Code for section access and section application) in another excel file.But after putting  access ,userid and password in excel and after calling the same it is not working can you please suggest on this.

Thanks in advance.

Regards,

Deepak

[deepakqlikview_123]

Please find below code for section access.

It is working fine as it is.

Section Access;


LOAD * INLINE



[

ACCESS, USERID, PASSWORD



ADMIN, ADMIN, ADMIN123



USER, HEAD,HEAD123

USER, A, USER123

];

Section Application;




LOAD * INLINE



[

USERID, Region



ADMIN,North

ADMIN,South

ADMIN,East

ADMIN,West

HEAD,North

A,South

];

But as per requirement I need to put all my user id pw and corresponding regions(Code for section access and section application) in another excel file.But after putting  access ,userid and password in excel and after calling the same it is not working can you please suggest on this.

Thanks in advance.

Regards,

Deepak