Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
rathnam_qv
Not applicable

Section access Issue

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.

2 Replies
vinieme12
Not applicable

Re: Section access Issue

please post your section access script

rathnam_qv
Not applicable

Re: Section access Issue

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