topic Section access for Objects security based on field criteria in QlikView

Section access for Objects security based on field criteria

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

I have a scenario where i need to secure an object based on a field (Country)

my section access code is:

SECTION Access;

LOAD ACCESS,

NTNAME

FROM

[\Data\User Access\User Access.xlsx]

(ooxml, embedded labels, table is Sheet1);

ChartAccessMatrix:

LOAD * INLINE [

NTNAME, CH01, CH02, Country_view

USER1,1,1,INDIA

USER2,1,1,CHINA

USER3,1,1,JAPA

];

NTNAME	ACCESS
USER1	ADMIN
USER2	USER
USER3	USER

Could you please suggest me how to apply a condition so that the object is visible only the user matches with the country.

Thanks

Sarathi

Re: Section access for Objects security based on field criteria

amit_saini — Tue, 24 May 2016 06:27:32 GMT

Hi ,

You can try something like below , change Plant by Country based on ur requirement.

Section Access;

Access:

LOAD ACCESS,

NTNAME,

upper(PLANT) as PLANT

FROM

[...\Flatfiles\Section_Application_Plant.xlsx]

(ooxml, embedded labels, table is WeeklyOPs)

where 1=1;

Section Application;

PlantAccess:

load

upper(PLANT) as PLANT,

PLANT as Plant

FROM

[....\Flatfiles\Section_Application_Plant.xlsx]

(ooxml, embedded labels, table is WeeklyOPs)

where 1=1;

and maintain excel like below:

Thanks,

Re: Section access for Objects security based on field criteria

MindaugasBacius — Tue, 24 May 2016 06:43:59 GMT

I would make little different.

Create two tables see the attachment:

The field Country have to be in your data model and have to be connected to the fact table.

In the script I would use these statements:

Section Access;
LOAD ACCESS, 
     NTNAME, 
     ROLE
FROM
[Source]
(ooxml, embedded labels, table is ACCESS);

Section Application;


PERMISSIONS:
LOAD ROLE, 
  Country
FROM
[Source]
(ooxml, embedded labels, table is PERMISSIONS);

Re: Section access for Objects security based on field criteria

sarathi_pm — Tue, 24 May 2016 13:44:20 GMT

Hi,

Thanks for your reply. I tried your option and its working.

Unfortunately, only the users with ADMIN access are able to open the qlikview document and the users with USER access are not able to open the file. it throws error "Access Denied to open the document'

But when i change the access to Admin, the users are able to open the file.

Any idea why is this happening?

Thanks

Sarathi

Re: Section access for Objects security based on field criteria

MindaugasBacius — Tue, 24 May 2016 14:21:20 GMT

I am not sure. I can only guess that the issue appears in:

QMC
QV application > Settings > Document properties > Security

Please check this blog post:

QlikView Section Access Examples