topic Re: REDUCTION - using two values from field in QlikView

REDUCTION - using two values from field

Mon, 26 Jan 2026 18:19:17 GMT

Which is the proper way to write the section access to allow a user to view two values from one particular field using REDUCTION in section access?

Section Access;

LOAD * INLINE [

ACCESS, NTNAME, DEPT, DEPT, DEPT

ADMIN, DOMAIN\ADMIN, *

USER, DOMAIN\USER1, DEPT1, DEPT2, DEPT3

USER, DOMAIN\USER2, DEPT2, DEPT3

USER, DOMAIN\USER3, DEPT3

];

Section Application;

or should it be:

Section Access;

LOAD * INLINE [

ACCESS, NTNAME, DEPT

ADMIN, DOMAIN\ADMIN, *

USER, DOMAIN\USER1, DEPT1

USER, DOMAIN\USER1, DEPT2

USER, DOMAIN\USER1, DEPT3

USER, DOMAIN\USER2, DEPT2

USER, DOMAIN\USER2, DEPT3

USER, DOMAIN\USER3, DEPT3

];

Section Application;

Any help would be greatly appreciated! Cheers

Re: REDUCTION - using two values from field

vincent_ardiet — Tue, 13 Oct 2015 03:23:58 GMT

Hi Rick,

The second one is the proper solution. The first one is not feasible because you are trying to create in the same table many fields with the same name.

In fact, your section access is a table like every others but just hidden in your datamodel.

Regards,

Vincent

Re: REDUCTION - using two values from field

Peter_Cammaert — Tue, 13 Oct 2015 10:11:14 GMT

An even better solution may be something like this:

Section Access;

LOAD * INLINE [

ACCESS, NTNAME, LINK

ADMIN, DOMAIN\ADMIN, *

USER, DOMAIN\USER1, USR1

USER, DOMAIN\USER2, USR2

USER, DOMAIN\USER3, USR3

];

Section Application;

DataPermissionsTable:

LOAD * INLINE [

LINK, Department

USR1, Dept_One

USR1, Dept_Two

USR1, Dept_Three

USR2, Dept_Two

USR2, Dept_Three

USR3, Dept_Three

];

This code allows you to put your section access code in a hidden script, while the actual data permissions table can be edited in your regular script (or read from an Excel).

Best,

Peter