Hi,
You are right, using OMIT the User will not see the field. Rather you need to use Field reduction. Something like this...
SECTION ACCESS;
LOAD * INLINE [
ACCESS, USERID, PASSWORD, COUNTRY
ADMIN, ADMIN, ADMIN,
USER, USER1, U1, USA
USER, USER2, U2, FRANCE
USER, USER3, U3, GBR
USER, USER3, U4, USA
USER, USER3, U4, FRANCE
USER, USER5, U5, *
];
Explanation :
USER1 will only see USA
USER2 will only see FRANCE
USER3 will only see GBR
USER4 will see everything except GBR (There are two rows in the above example, you need to add 9 rows in your case)
USER5 will see everything because I'm using "*" (Wild Card)
Please be very careful using the '*' (Wildcard) because it doesn't mean all the values in the Actual Field. It means distinct values you have specified in Section Access Table. Unless you have specified all the distinct values within Section Access.
In your Section Access example, you have specified Country values as {GBR,USA,FRANCE} but if your actual Country field contains{GBR,USA,FRANCE,GERMANY,INDIA,.....} then you won't see {GERMANY,INDIA,*****} rows even if the User has '*' in Section Access. It will ONLY take all the values from Section Access but not all the values from actual field.
I hope that makes sense.
I'm also attaching simple documentation on Section Access.
Good luck!
Cheers,
DV
www.QlikShare.com
.png "Luminary Alumni"){kind=icon}
