Section access help

savithri_n_s — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Section access help

lfetensini — Mon, 29 Apr 2019 19:04:23 GMT

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)],
...

topic Section access help in QlikView

Section access help

Re: Section access help