Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
priyanka08
Contributor III
Contributor III

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

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 ;

 

Labels (1)
1 Reply
BrunPierre
Partner - Master II
Partner - Master II

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

BrunPierre_1-1669230353554.png