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

[kaushiknsolanki]

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

[savithri_n_s]

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

[kaushiknsolanki · Accepted solution]

Hi,

Remove those existing created filters and add new one.

Regards,

Kaushik Solanki

[savithri_n_s]

Thank you soo much kaushik

[savithri_n_s]

Thank you soo much

[kaushiknsolanki]

Cheers,

Kaushik Solanki