topic Section Access in QEMC in QlikView

Section Access in QEMC

Mon, 26 Jan 2026 18:19:17 GMT

1. How to implement section access in QEMC 9.0 ?

2. What is the Usage of Section Access mentioned under QEMC -> sETUP - > Advanced tab.

Section Access in QEMC

Miguel_Angel_Baeyens — Wed, 27 Apr 2011 08:35:16 GMT

Hi,

1. Section access is always at a document level, meaning you code it in the document script, and meaning that you may have two documents with different section access. Search a bit in the forums and you will find several dozens of posts and sample codes covering the different fields and ways to get the section access working.

2. I don't have such setting. What version are you using? Can you please elaborate on how to get to that "Advanced" tab?

Regards.

Section Access in QEMC

Wed, 27 Apr 2011 10:22:29 GMT

For point 2, can I say that you use QV Publisher?

The difference is you can hv centralized section access and you can reuse it for other files

Section Access in QEMC

Wed, 27 Apr 2011 10:36:58 GMT

hi,

you may define a section access in your script as

Section access;

Acces_table:

ACCESS, USERID, [PASSWORD, FIELD1, FIELD2...]
Admin, Name, [pwd, Dept, field...]
User, Name, [pwd, Dept, field...]

you can ever load it from a table or a file as

LOAD DISTINCT
'USER' as ACCESS,
Name as USERID,
Pass as PASSWORD,
Dept_name as DEPT
...

RESIDENT Table

Don't forget to save a copy beifre loading in case you messed up the content of this section, you wouldn't be able to open it again!!

open the your section application and get relation with access table

section application;

star is *;

Reduc_Data_table:
load * inline [
DEPT, Territorycode
0, *
];
LOAD
Territorycode as DEPT,
Territorycode
RESIDENT Terr_Table;

this will give all access to DEPT = 0 and reduce date to other accordiing value of DEPT.

Tick the option "Data reduction based on section access" in "Setting, opening"

regards

christian

Section Access in QEMC

Thu, 28 Apr 2011 06:15:18 GMT

Thanks for your reply.

I wanted to clarify the Section Access mentioned in QEMC in the following tab:

System -> Setup -> Distribution Services -> Advanced Tab -> Section Access

Section Access in QEMC

Thu, 28 Apr 2011 06:30:19 GMT

I am sending a pdf attached with that reply...

May be it will help you..

Thanks & Regards,

Deep