Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
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
jonathandienst
Partner
Partner

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

View solution in original post

6 Replies
jonathandienst
Partner
Partner

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
Author

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
Partner
Partner

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

View solution in original post

anantmaxx
Specialist
Specialist

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
Creator III
Creator III

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
Author


Indeed. That was the issue...

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

Thanks for the tip!