topic Section access help in QlikView

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

kaushiknsolanki — Sat, 27 Apr 2019 18:37:59 GMT

Hi,

Your script should be like this.

Section Access;

LOAD ACCESS, USERID, PASSWORD, upper(GU) as GU, upper(OG) as OG 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, USER3, U3, ANZ,CMT

];

Regards,

Kaushik Solanki

Re: Section access help

savithri_n_s — Sat, 27 Apr 2019 19:18:30 GMT

Hello Kaushik,

Thanks.Data is getting filtered however OG and GU in the filter in each tab is showing as unavailable as shown above.

Can you please help?

Regards,

Savithrii

Re: Section access help

kaushiknsolanki — Sat, 27 Apr 2019 19:41:10 GMT

Hi,

Remove those existing created filters and add new one.

Regards,

Kaushik Solanki

Re: Section access help

savithri_n_s — Sun, 28 Apr 2019 06:04:45 GMT

Thank you soo much kaushik

Re: Section access help

savithri_n_s — Sun, 28 Apr 2019 06:09:16 GMT

Thank you soo much

Re: Section access help

kaushiknsolanki — Mon, 29 Apr 2019 09:37:45 GMT

Cheers,

Kaushik Solanki