Hi Dagan, this my way of proceeding, if you copy those steps on the base of your own example, you have then automaticaly the solution to your issue:
step 1:
load following scrip:
// Section Access
Access:
Load * INLINE [
Access, USERID, PASSWORD, Link
ADMIN, admin, admin, *
USER, user1, user1, US
USER, user2, user2, UK
];
Sales
Load * Inline [
Link, Country, Sales
US, USA, 150
UK, United Kingdom, 250
];
then you shoud save as Securty1.qvw and reload
and conform that each user is associated with the values that are expected ( you see: as admin you will not be associated with any countries- this is ok)
Save your document as Security2.qvw.and edit the script and uncomment the Section Access Statement. and again you should reload your document and the USERID fiélds will become unavailable.
now, very importing steps:
Settings menu > Select Document Properties and click on the Opening tab and turn on the Initial Data Reduction Based on Section Access Option. Make sure that Sctrict Exclusion is selected
Save and Close your Document:
from the Settings menu, select User Preferences, make sure that the Remember Login Credentials Until QlikView Exits Option is unchecked and click OK
Reopen your document Security2.qvw, try logging in as any of users (user1/user2). it is expected that the users see only one Country. Close your document and reopen it and log in as admin. Edit the script and in the Access table, Change the Link field Name from Link to LINK.Repeat this step for Link field in the Sales table.
Reload and save your document. Close and reopen the document. Log in ac user1. only USA should be listed. the same step you can use for User2, and if you log in as User2 so you see only United Kingdom
Dagan, let me know you have any questions. i hope that helps
beck
