You need to create a section access, so QlikView can distinguish between user access and admin access. Note that if your deployment uses clients (AJAX or IE Plugin) all users are granted USER privileges, even if you have set them as ADMIN in the ACCESS field of section access. In other words, opening on server in Desktop, using IE Plugin and AJAX will not allow users to save or edit script or macro.
Besides, make sure that in the Settings menu, Document Properties, Open tab, "Initial Data Reduction..." and "Strict Exclusion" are unchecked.
// Sample Section AccessSECTION ACCESS;// Fields below are mandatoryLOAD * INLINE [ ACCESS, USERID, PASSWORDADMIN, ADMIN, ADMINUSER, USER1, USER1]; SECTION APPLICATION;// You script starts here
Hope that helps.
Thanks for replay.
i use like that below here:
ACCESS, NTNAME, NTDOMAINSID
ADMIN, ADMINISTRATOR, S-1-5-21-4098164516-3443508128-318809462
USER, SAKYUZ, S-1-5-21-4098164516-3443508128-318809462
I would like to do specific user access.
EX: HR Department have to see only sheet1 and sheet2, Accounting Department have to see only sheet3 and sheet4 in the same doc....
How can i do ?
Thanks in advance...
I'd do groups for users in a field out of the section access, and apply those fields to the conditional view of the sheet, in the sheet properties, General, Show Sheet, Conditional:
Section Access; LOAD * INLINE [ACCESS, NTNAME, NTDOMAINSIDADMIN, ADMINISTRATOR, S-1-5-21-4098164516-3443508128-318809462USER, SAKYUZ, S-1-5-21-4098164516-3443508128-318809462 ]; Section Application; UsersGroupsMap: // loaded manually, you can load from database or excel sheet for exampleLOAD * INLINE [ USERNAME, GROUPDOMAIN\ADMINISTRATOR, ADMINSDOMAIN\SAKYUZ, HRDOMAIN\USER1, SALES]; Groups:LOAD OSUser() AS User, ApplyMap('UsersGroupsMap', OSUser()) AS GroupAUTOGENERATE 1;
Now Sheet1 has conditional
Match(Group, 'HR', 'ADMINS')
Meaning that the sheet will be visible for users in group HR or ADMINS according to the sample above.
Note that NTNAME must match what OSUser() returns (usually in the form of DOMAIN\UserName) otherwise you will be locked out, so backup your document before reloading.
Hope that helps.
Addition to what Mrigun Says
You have to define what all the users can access and admin can access
for that go to Document Prooerties--> Security --> and removes the checks that you want to disable for the users.
and also make sure to check on Admin Override Security. It will be uncheck by default.
Save your application Close your Desktop.
Then Start Playing with it after opening again
Hope this is what you are looking for.