Section access help

[savithri_n_s]

Hello Team,

I have applied Qlik view section access as below. the password is 123

The data on each tab is not excluded as per the section access with users given below.

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, upper(GU) as GU, upper(OG) as OG

ADMIN, ADMIN, ADMIN

USER, USER1, U1, ICEG,RES

USER, USER2, U2, UNITED STATES,OTHER

USER, USER3, U3, ASEAN,PRD

USER, USER3, U3, ANZ,CMT

];

Section Application;

Please can you help me to understand why it is not working?

Regards,

Savithri

[lfetensini]

First:

Section Access must be in the front of your script, not at end. After "Section Access" came "Section Application". Makes Sense?


Second: You cant write commands inside Load * Inline like "Upper". In the same time, your DATA already in Caption.


Third: You can reduce one field per time. If you want reduce two, its necessary concat them, like: GU & '|' & OG as _GU_OG




Script example:




SECTION Access;

LOAD * INLINE [
ACCESS, USERID, PASSWORD, _GU_OG
ADMIN, ADMIN, ADMIN, *
USER, USER1, U1, ICEG|RES
USER, USER2, U2, UNITED STATES|OTHER
USER, USER3, U3, ASEAN|PRD
USER, USER4, U4, ANZ|CMT
];


Section Application;


Table1:
Load
Upper(OG) & '|' & Upper(GU) as _GU_OG, // Section Access
Upper(OG) as [OG_SA],
Upper(GU) as [GU_SA],
[Business Dimensions (Express Requisition)],
...