I have attached a Sample file
I have implemented row level , object and sheet level section access. All section access works perfectly fine except sheet level section. I tried everything is not working it take by default qlikview account. If I put 0 in all tabor name for qlikview account it display all , if I hide some tab for qlikview account it hide those. However country and region filter out on the basis of my dashboard.
Tab name- main,summary,details,Anaysis,Report
TempSectionAccess:
LOAD Distinct *
FROM
$(vStage0_QvdPath)Manual\SectionAccess.qvd(qvd) Where dashboard=1 ;
STAR IS *;
SECTION Access;
Userslist:
LOAD UPPER(TRIM(userid)) as NTNAME,//NTNAME, USERID
UPPER(TRIM(access)) as ACCESS,
UPPER(TRIM(countrygroup)) as COUNTRYGROUP,
UPPER(TRIM(Marketaccess)) as GROUP_WMNC_ACCESS,
UPPER(TRIM(Region_access)) as GROUP_LPS_ACCESS,
UPPER(TRIM(Segment_access)) as GROUP_DEBTOR_GRM_ACCESS,
Users_access_control_country_list:
LOAD * INLINE [
COUNTRYGROUP, Market
COUNTRY_GROUP_SG, SG
COUNTRY_GROUP_UK, UK
COUNTRY_GROUP_KR, KR
COUNTRY_GROUP_HK, HK
COUNTRY_GROUP_CN, CN
COUNTRY_GROUP_TW, TW
COUNTRY_GROUP_IN, IN
COUNTRY_GROUP_AU, AU
GROUP_ALL, SG
GROUP_ALL, HK
GROUP_ALL, CN
GROUP_ALL, TW
GROUP_ALL, IN
GROUP_ALL, VN
GROUP_ALL, AU
GROUP_ALL, KR
GROUP_ALL, UK
];
Sheet_Security:
UPPER(TRIM(userid)) as NTNAME,
main,summary,details,Anaysis,Report
FROM
$(vStage0_QvdPath)Manual\SectionAccess.qvd(qvd) Where dashboard=1 ;
