Hi Abhay,
Please try as below:
“Settings” -> “Document Properties” -> “Opening” --
Tick the checkbox “Initial Data Reduction Based on Section Access”
to enable section access in the document.
And also Tick the checkbox “Strict Exclusion” - Access to the document will be denied whenever the field values in the section access reduction fields lack matches in their corresponding section application field. Having this option unselected will mean that if QlikView can’t find a match to reduce data, all data in the document will be visible on USER level. However, ADMIN will always be able to see all data, regardless of the reduction. Best practice is to use strict exclusion to avoid unwanted access to the QlikView document.
Write below code in hidden script:
Section access for Zone & Region wise Sales for report1
Section Access;
LOAD * INLINE [
ACCESS, USERID, PASSWORD, REGION,ZONE
ADMIN, ADMIN, ADMIN,
USER, USER1, U1, ,*
USER, USER2, U2, *, ];
Section Application;
SALES: LOAD * INLINE [
REGION,ZONE,SALES
AFRICA,ZONE1,1000
AMERICA,ZONE2, 2000
ASIA,ZONE3, 3000
EUROPE,ZONE4, 4000
OCEANIA,ZONE5, 5000 ];
Section access for Zone & Region wise Budget for report2
Section Access;
LOAD * INLINE [
ACCESS, USERID, PASSWORD, REGION,ZONE
ADMIN, ADMIN, ADMIN,
USER, USER1, U1,* ,
USER, USER2, U2,,* ];
Section Application;
SALES: LOAD * INLINE [
REGION,ZONE,BUDGET
AFRICA,ZONE1,1000
AMERICA,ZONE2, 2000
ASIA,ZONE3, 3000
EUROPE,ZONE4, 4000
OCEANIA,ZONE5, 5000 ];
Regards
Neetha
