Qlik Community

Qlik Sense App Development

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

Announcements
Uploads getting stuck in the virus scanner. We are investigating.
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

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
Highlighted
Champion II
Champion II

please post your section access script

Highlighted
Creator
Creator

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