topic Authorization in qlikview in QlikView

Authorization in qlikview

deepakqlikview_123 — Mon, 26 Jan 2026 18:19:17 GMT

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.

Amità Regional Manager for East
Sumità Regional Manager for West
Suhasà Regional Manager for North
Nitinà Regional Manager for South

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

Thanks,

Re: Authorization in qlikview

Fri, 04 Oct 2013 10:02:43 GMT

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

Re: Authorization in qlikview

Fri, 04 Oct 2013 10:05:54 GMT

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

Re: Authorization in qlikview

deepakqlikview_123 — Mon, 07 Oct 2013 04:54:56 GMT

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,

Re: Authorization in qlikview

senpradip007 — Mon, 07 Oct 2013 05:31:25 GMT

Hi Deepak,

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

Hope it will help.

Re: Authorization in qlikview

deepakqlikview_123 — Mon, 07 Oct 2013 06:44:20 GMT

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,

Re: Authorization in qlikview

bbi_mba_76 — Mon, 07 Oct 2013 07:52:31 GMT

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

Re: Authorization in qlikview

deepakqlikview_123 — Mon, 07 Oct 2013 09:14:50 GMT

Hi Michele,

I haven't selected that option

Thanks,

Re: Authorization in qlikview

deepakqlikview_123 — Wed, 30 Oct 2013 11:58:30 GMT

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

Re: Authorization in qlikview

deepakqlikview_123 — Wed, 30 Oct 2013 15:24:07 GMT

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

];

Thanks in advance.

Regards,

Deepak

Re: Authorization in qlikview

deepakqlikview_123 — Wed, 30 Oct 2013 15:24:19 GMT

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

];

Thanks in advance.

Regards,

Deepak

Re: Authorization in qlikview

deepakqlikview_123 — Wed, 30 Oct 2013 15:24:37 GMT

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

];

Thanks in advance.

Regards,

Deepak