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,

[#2]

Hi Deepak,

First create a section accession where to set the rights:

Section Access;

LOAD

* INLINE

[
ACCESS, USERID, PASSWORD, REGION

ADMIN, ADMIN, ADMIN123, *

USER, HEAD,HEAD123,*
USER, A, USER123, EAST
USER, B, USER456, WEST
USER, C, USER789, NORTH

USER, D, USER345, SOUTH
];

If a user may see severel regions, just repeat the line but with another REGION.

Take care also that the fields MUST be UPPERCASE

Take care also that the * does NOT mean anything, but everything listed below (here it is OK because you have the 4 regions)

SECTION Application;

Here you will your data. I assume you have a REGION field to do the link with the rights.

If you need to intersect (REGION / PRODUCT) you will need to create a composite key.

Fabrice

[#3]

http://community.qlik.com/docs/DOC-1853

[deepakqlikview_123]

Hello Expert,

When I have created script as per mentioned above right now it is showing data only for west region.

Though I have removed the hidden script the problem still occurs.I am only able to see data for west region.

Can you please suggest on this.

Thanks,

[senpradip007]

Hi Deepak,

You can use either Section Access and Section Application feature in QlikView or impliment this through QlikView Publisher.

Hope it will help.

[deepakqlikview_123]

Hello FABRICE,

Although after making above changes in a script it is still showing me all regions for all users.

It is not able to give access as per mentioned in a script.

Can you please suggest on this.

Thanks,

[bbi_mba_76]

In document properties, opening tab, have you marked the initial data reduction based on section access ?

[deepakqlikview_123]

Hi Michele,

I haven't selected that option

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