topic Re: Section access data reduction in QlikView

Section access data reduction

Mon, 24 Mar 2014 09:25:51 GMT

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?

Re: Section access data reduction

jonathandienst — Mon, 24 Mar 2014 09:55:34 GMT

Perhaps the field NTNAME needs to have a domain qualifier:

myDomain\myName

HTH

Jonathan

Re: Section access data reduction

Mon, 24 Mar 2014 10:25:15 GMT

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?

Re: Section access data reduction

jonathandienst — Mon, 24 Mar 2014 10:28:24 GMT

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

HTH

Jonathan

Re: Section access data reduction

Anonymous — Mon, 24 Mar 2014 10:42:11 GMT

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

Re: Section access data reduction

arsal_90 — Mon, 24 Mar 2014 10:45:58 GMT

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
]

;

Re: Section access data reduction

Mon, 24 Mar 2014 10:57:26 GMT

Indeed. That was the issue...

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

Thanks for the tip!