Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi
Perhaps you should move the Cost_Centres table to after Section Application.
HTH
Jonathan
Hi
Perhaps the field NTNAME needs to have a domain qualifier:
myDomain\myName
HTH
Jonathan
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?
Hi
Perhaps you should move the Cost_Centres table to after Section Application.
HTH
Jonathan
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
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
]
;
Indeed. That was the issue...
I thought the Statement "Section application" actually meant "Begining of the actual code..."
Thanks for the tip!