So I created a Dashboard for my team and I am hoping to share access with the rest of my team. How can I give them this access, while restricting them any editing privleges?
I have a team that I work with who will utilize the functionalities of the dashboard, but I want to keep it so that only I can edit the dashboard.
Anyway that I can accomplish this (maybe by having it password protected to open) I would be fine with. this is the first phase, so we are looking to eventually pubish it and give its own URL, but for the time being, I just want me at the back end to be able to edit, upload, refresh, etc while my colleagues can view each tab, press the filter buttons, and retrieve data they need, like send to excel, print, etc.
I hope this explains what I am trying to accomplish.
Ok, it will be pretty easy. I would use section access. You need to include something like this, at the beginning of your script:
Section Access;
LOAD * INLINE [
ACCESS, USERID, PASSWORD
ADMIN, ADMIN, ADMIN
USER, USER1, USER1
USER, USER2, USER2
];
Section Application;
After 'Section Application' would be your code. It is pretty obvious the structure in the inline table. Column ACCESS define is it a USER or ADMIN. Column USERID: username, column PASSWORD: password. You could create record for each user you would like to use this application. You need also to filter the user rights in: menu Settings->Document Properties->Security. Here you could define user rights. Make sure the the last checkbox 'Admin overrides security' is checked. You could also revise the user rights in each sheet: Right click on blank space in the sheet, click on 'Properties' and go to security. You could easily apply the same settings to each sheet.
Good practice is load the section access table from an external .xlsx file, so if you make something wrong to be able to repair it outside QlikView. Also make a copy of your file before including Section Access, just in case.
