Discussion Board for collaboration related to QlikView App Development.
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
QUALIFY *;UNQUALIFY %Cost_centre;TABLEA:LOAD
CS as %Cost_centre, F1 as Field_1,
F2 as field_2FROM [$(ServerPath)\$(SourceDataPath)\file.xls](biff, embedded labels, table is table);
Am I doing something wrong?
Perhaps you should move the Cost_Centres table to after Section Application.
View solution in original post
Perhaps the field NTNAME needs to have a domain qualifier:
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?
just check by writing section application ; above your COST_CENTRES: table
COST_CENTRES:LOAD * INLINE
Use that script
= 'Y';Section Application;
Indeed. That was the issue...
I thought the Statement "Section application" actually meant "Begining of the actual code..."
Thanks for the tip!