Section access data reduction

[#1]

I'm having an issue with my Section Access data reduction on QV 10 SR2.

With the code below i would expect the user below ROGOWSB (ADMIN) to only see the %Cost_centre specified in the COST_CENTRES table while accessing the app through Access point but it's not happening.

Note: Initial data reduction and Strict exlusion are ticked in the document's properties.

Section Access;
UNQUALIFY * ;
ACCESS:
LOAD NTNAME,
[ACCESS]
FROM
[PATH\\External\QlikView User List.xls]
(biff, embedded labels, table is [Go Live$]) where [COSTREPORT]

= 'Y';

COST_CENTRES:
LOAD * INLINE

[
NTNAME, %Cost_centre
ROGOWSB,AB43
ROGOWSB,AB87
ROGOWSB,GCS50357
ROGOWSB,GRG05
ROGOWSB,GRP01
ROGOWSB,GRP05
ROGOWSB,HKGIAAP
ROGOWSB,HKZB102D
ROGOWSB,HKZU103X
ROGOWSB,IAD05
]

;
Section Application;

QUALIFY *;
UNQUALIFY %Cost_centre;
TABLEA:
LOAD

CS as %Cost_centre,
F1 as Field_1,

F2 as field_2
FROM [$(ServerPath)\$(SourceDataPath)\file.xls]
(biff, embedded labels, table is table);

Am I doing something wrong?

[jonathandienst]

Hi

Perhaps the field NTNAME needs to have a domain qualifier:

myDomain\myName

HTH

Jonathan

[#3]

The section access works fine without the domain name.

It's just that somehow my Cost_centre reduction doesn't seem to work...

Can it be done in several tables the way I did it?

[jonathandienst · Accepted solution]

Hi

Perhaps you should move the Cost_Centres table to after Section Application.

HTH

Jonathan

[Anonymous]

just check by writing   section application ;   above your COST_CENTRES: table

Section Application;

COST_CENTRES:
LOAD * INLINE

[
NTNAME, %Cost_centre
ROGOWSB,AB43
ROGOWSB,AB87
ROGOWSB,GCS50357
ROGOWSB,GRG05
ROGOWSB,GRP01
ROGOWSB,GRP05
ROGOWSB,HKGIAAP
ROGOWSB,HKZB102D
ROGOWSB,HKZU103X
ROGOWSB,IAD05
]

;

ANANT

[arsal_90]

Use that script

Section Access;
UNQUALIFY * ;
ACCESS:
LOAD NTNAME,
[ACCESS]
FROM
[PATH\\External\QlikView User List.xls]
(biff, embedded labels, table is [Go Live$]) where [COSTREPORT]

= 'Y';
Section Application;

COST_CENTRES:
LOAD * INLINE

[
NTNAME, %Cost_centre
ROGOWSB,AB43
ROGOWSB,AB87
ROGOWSB,GCS50357
ROGOWSB,GRG05
ROGOWSB,GRP01
ROGOWSB,GRP05
ROGOWSB,HKGIAAP
ROGOWSB,HKZB102D
ROGOWSB,HKZU103X
ROGOWSB,IAD05
]

;

[#7]

Indeed. That was the issue...

I thought the Statement "Section application" actually meant "Begining of the actual code..."

Thanks for the tip!