Reduction & Distribute with Publisher doc with Section Access

Mon, 26 Jan 2026 18:19:17 GMT

Hi all,

I have an app with Section Access like that:

LOAD

upper('ADMIN') AS ACCESS,

upper(EMPLIDAC) AS NTNAME,

upper(EMPLIDAC) AS LOGIN

FROM QVD_SEGUR.qvd

One Field has connection with data model: LOGIN.

I need to reduce data by other field (office) and generate one .qvw per office.

Each office has several LOGIN and we need to create one doc per office but each doc has all estructure of section access.

The doc has a "Initial data reduction based on section access" and "Strict exclusion".

When I run reduction in Publisher per office it works ok, but I have just one user, the user of service. This person is the one who opens the doc to make the reduction and distribution.

The problem is didnt keep all users in section access.

I hope explained well.

Thanks

Re: Reduction & Distribute with Publisher doc with Section Access

Thu, 26 Dec 2013 12:26:16 GMT

I found the solution,

Just including "NOREDUCTION" in line of user of service:

LOAD * INLINE [
ACCESS, NTNAME, LOGIN, LOGIN2, EMPLPUES
ADMIN,"QLIKVIEWSERVICE",NOREDUCTION
];

This ensures that if the document is opened with this user, the reduction is not performed if the doc has "Initial data reduction based on section access" and "Strict exclusion".

I hope its useful

Regards

topic Re: Reduction & Distribute with Publisher doc with Section Access in QlikView

Reduction & Distribute with Publisher doc with Section Access

Re: Reduction & Distribute with Publisher doc with Section Access