Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rathnam_qv
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
vinieme12
Champion III
Champion III

please post your section access script

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
rathnam_qv
Creator
Creator
Author

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