Section access Issue

[rathnam_qv]

Hi All,

PFA

i have implemented section access in qlik server.

it applying security but the issue is along with the region on which i applied security remaining also coming as grayed values in the filter.

can anyone help on this.

Thanks,

Muni.

[vinieme12]

please post your section access script

[rathnam_qv]

Hi Vineeth,

Thsnk u for your response.

i am using Excel.

PFB code

Security:

LOAD

    "ACCESS",

    "USERID",

    "USER NAME",

    Q01A_BUSINESS_REGION_NAME,

    Q01B_BUSINESS_REGION_NAME,

    Q01C_BUSINESS_REGION_NAME,

    Q01V_BUSINESS_REGION_NAME,

    Q02_BUSINESS_REGION_NAME,

    Q03_BUSINESS_REGION_NAME,

    Q05_BUSINESS_REGION_NAME,

    Q06_BUSINESS_REGION_NAME,

    Q061_BUSINESS_REGION_NAME,

    Q08_BUSINESS_REGION,

    Q09_BUSINESS_REGION,

    Q10_BUSINESS_REGION_NAME,

    Q11_GLOBAL_REGION,

    Q14_BUSINESS_REGION_NAME,

    Q15_BUSINESS_REGION_NAME,

    Q16_BUSINESS_REGION_NAME,

    Q21_REGION

FROM [lib://Files/EP_EMEA_SECTION_ACCESS.xlsx]

(ooxml, embedded labels, table is SectionAccess_Admin);

Concatenate(Security)

LOAD

    "ACCESS",

    "USERID",

    "USER NAME",

    Q01A_BUSINESS_REGION_NAME,

    Q01B_BUSINESS_REGION_NAME,

    Q01C_BUSINESS_REGION_NAME,

    Q01V_BUSINESS_REGION_NAME,

    Q02_BUSINESS_REGION_NAME,

    Q03_BUSINESS_REGION_NAME,

    Q05_BUSINESS_REGION_NAME,

    Q06_BUSINESS_REGION_NAME,

    Q061_BUSINESS_REGION_NAME,

    Q08_BUSINESS_REGION,

    Q09_BUSINESS_REGION,

    Q10_BUSINESS_REGION_NAME,

    Q11_GLOBAL_REGION,

    Q14_BUSINESS_REGION_NAME,

    Q15_BUSINESS_REGION_NAME,

    Q16_BUSINESS_REGION_NAME,

    Q21_REGION

FROM [lib://Files/EP_EMEA_SECTION_ACCESS.xlsx]

(ooxml, embedded labels, table is SectionAccess_User);

Section Access;

LOAD

    "ACCESS",

    "USERID",

    "USER NAME",

    Q01A_BUSINESS_REGION_NAME,

    Q01B_BUSINESS_REGION_NAME,

    Q01C_BUSINESS_REGION_NAME,

    Q01V_BUSINESS_REGION_NAME,

    Q02_BUSINESS_REGION_NAME,

    Q03_BUSINESS_REGION_NAME,

    Q05_BUSINESS_REGION_NAME,

    Q06_BUSINESS_REGION_NAME,

    Q061_BUSINESS_REGION_NAME,

    Q08_BUSINESS_REGION,

    Q09_BUSINESS_REGION,

    Q10_BUSINESS_REGION_NAME,

    Q11_GLOBAL_REGION,

    Q14_BUSINESS_REGION_NAME,

    Q15_BUSINESS_REGION_NAME,

    Q16_BUSINESS_REGION_NAME,

    Q21_REGION

Resident Security;

Section Application;

Star is '*';

//drop Table Security;

Thanks,

Muni