How can I restrict access to documents on QlikView AccessPoint

[EhsanPrv]

Hi

I have multiple QlikView dashboards which are available at QlikView AccessPoint. The number of these dashboards increase every year. They should be filtered based on logged in user. Is there any way to filter all my reports on QMC level?

[Albert_Candelario · Accepted solution]

Hello @EhsanPrv ,

Could you expand what is your requirement?

You can to see the dashboard been access for a certain user?

If so, I would recommend you starting by deploying the Governance Dashboard

Getting started with the Governance Dashboard ‒ QlikView Governance Dashboard

Cheers,

Albert

[EhsanPrv]

Hello Albert

my client is a software academy and more than 300 teachers are working there. I have provided some dashboards for these teachers (such as their weekly schedule, withdrawal students, groups and classes...) and all of these dashboards are available on QlikView server. now they asked me to filter all these dashboards based on the logged in user (teacher) so that each teacher can only see their own data

[Albert_Candelario · Accepted solution]

Hello @EhsanPrv ,

Thanks for the clarification. In QlikView you have 2 options. Either you restrict the data each user can see by section access, information below:

Security ‒ QlikView

It also explain that if you have a Publisher a qvw can be created for each user with the data they need to see.

Some more examples:
QlikView Section Access Examples - Qlik Community - 1492719

Or that user only see documents on the Access Point based on the Section access:

Document Properties: Server ‒ QlikView

Section - Filter AccessPoint Document List Based on Section Access

I do hope this indeed resolves your requirements.

Finally, notice the 2nd option does NOT exist for Qlik Sense client-managed.

Qlik Sense: Filter Document List Based On Section Access

Cheers,

Albert

[EhsanPrv]

Dear Albert

Thank you so much for your time and these amazing information.

Now I have another problem actually. I tried to reduce data via section access. it works like a charm for users with "USER" access, but it also reduces data for ADMINS.

here is my script(I have also ticked "Initial data reduction based on section access" in Document properties--> opening):

star is *;
section Access;
SQL SELECT ACCESS,
case when ACCESS = 'ADMIN' then '*' else `Moodle_USERID` END as USERID_TKN,
case when ACCESS = 'ADMIN' then '*' else `Moodle_USERID` END as USERID_CAP,
upper(USERID) as NTNAME,
'*' as PASSWORD,
'*' as USERID
FROM <MyUsersTable>;
concatenate
load * inline [ACCESS , USERID_TKN, USERID_CAP, NTNAME, PASSWORD, USERID
ADMIN, , , , 123, RELOADER
ADMIN, , , SRV-QVS\ADMINISTRATOR , * , *
];

section Application;

as you can see, I want to reduce data based on two fields (USERID_TKN , USERID_CAP)

[Albert_Candelario]

Hello @EhsanPrv ,

I am glad you appreciated my help.

If you do not mind, I would ask you to open a new discussion instead of following here, so other users from the Community can benefit in the future if having a similar case, so the subject of the same can lead them into the new discussion.

Feel free to tag me on the new discussion once created. In the meantime, I will start reviewing the content you already shared.

Cheers,

Albert