Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
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

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

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

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!