Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

Section access data reduction

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?

1 Solution

Accepted Solutions
MVP
MVP

Re: Section access data reduction

Hi

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

HTH

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
6 Replies
MVP
MVP

Re: Section access data reduction

Hi

Perhaps the field NTNAME needs to have a domain qualifier:

myDomain\myName

HTH

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable

Re: Section access data reduction

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?

MVP
MVP

Re: Section access data reduction

Hi

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

HTH

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
anantmaxx
Valued Contributor

Re: Section access data reduction

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

Highlighted
arsal_90
Contributor III

Re: Section access data reduction

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
]

;

Not applicable

Re: Section access data reduction


Indeed. That was the issue...

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

Thanks for the tip!