topic Re: Sharing Access to QlikView Report in QlikView

Sharing Access to QlikView Report

Wed, 25 Nov 2020 16:16:04 GMT

Hey Qlik Community,

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?

Thanks in advance,

Tej

Re: Sharing Access to QlikView Report

ankali1990 — Tue, 09 Aug 2016 16:55:22 GMT

Hi,

could you tell us how do you plan to share this dashboard?

You could create section access and for example to define your colleagues' NT names as USERs and your NT name as ADMIN.

More about QlikView section access:

Introduction to Section Access

QlikView Section Access Examples

Hope it helps,

BR.

Re: Sharing Access to QlikView Report

Tue, 09 Aug 2016 17:44:00 GMT

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.

Thanks,

Tej

Re: Sharing Access to QlikView Report

ankali1990 — Tue, 09 Aug 2016 18:42:45 GMT

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.

Hope it helps.

BR.