Sheet Level section access not working , Row level & object level section acces working in the same dashboard in qlikview

priyanka08 — Wed, 23 Nov 2022 13:16:44 GMT

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 ;

Re: Sheet Level section access not working , Row level & object level section acces working in the same dashboard in qlikview

BrunPierre — Wed, 23 Nov 2022 19:06:24 GMT

How about with a script like this, and showing the sheets conditionally?

Script

Sheet_Security:
LOAD * Inline[
NTNAME,SHEET1,SHEET2,SHEET3,SHEET4,SHEET5
JAMES,1,1,1,1,1
MICHAEL,0,1,1,1,1
KOBE,1,1,1,0,0
MAGIC,0,0,0,0,1];

Sheet configuration

topic Sheet Level section access not working , Row level & object level section acces working in the same dashboard in qlikview in App Development

Sheet Level section access not working , Row level & object level section acces working in the same dashboard in qlikview

Re: Sheet Level section access not working , Row level & object level section acces working in the same dashboard in qlikview