topic Re: Section Access doesn't reduce data in QlikView

Section Access doesn't reduce data

Peony — Mon, 14 Mar 2022 17:30:49 GMT

Hi all.

Request your help with section access. There is my code below:

Table: Load * Inline [ CostCentre A B C D ]; Section Access; Star is *; Access: LOAD * Inline [ Access, UserID, Password, CostCentre USER, USER, USER, * ADMIN, ADMIN, ADMIN, * USER, JOHN, JOHN, A USER, MARY, MARY, B USER, PETER, PETER, C ADMIN, SIMON, SIMON, A ]; Section Application;

For some reason, once I login as one of the user, let's say as JOHN, I still see all Cost Centre instead of A only. I don't understand what am I doing wrong with section access?

Re: Section Access

Albert_Candelario — Sun, 13 Mar 2022 20:20:47 GMT

Hello @Peony ,

Thanks for posting.

In the section access table for the fields ACCESS, USERID,... as per the guide I always use them in capital letters and then the application would need to be reloaded again.

I assume the value of the blue square if the one for the UserID of the user who has login, so there is no need to use NTNAME or another field instead.

Apart from the capital topic, the rest seems ok as far as I could see. Maybe someone else on the Community has a further insight.

Cheers,

Albert

Re: Section Access

Peony — Mon, 14 Mar 2022 17:30:12 GMT

Hi @Albert_Candelario Thank you for response.

I changed fields names into capital letters, reloaded and unfortunately data still not reduced for any user.

As for the blue square, I use there QvUser().

Re: Section Access doesn't reduce data

elyMalkiAcn — Mon, 14 Mar 2022 18:35:36 GMT

[Table]: noConcatenate Load * Inline [ CostCentre A B C D ]; Star is *; [Access]: noConcatenate LOAD * Inline [ ACCESS, USERID, PASSWORD, CostCentre USER, USER, USER, * ADMIN, ADMIN, ADMIN, * USER, JOHN, JOHN, A USER, MARY, MARY, B USER, PETER, PETER, C ADMIN, SIMON, SIMON, A ]; Section Access; Access_SA: noConcatenate load ACCESS ,USERID ,PASSWORD ,CostCentre resident [Access]; Section Application; drop Table [Access];

This is possible solution on Script side

BR,

Ely

Re: Section Access doesn't reduce data

marcus_sommer — Tue, 15 Mar 2022 08:59:32 GMT

Did you enable the section access within the document properties in tab open? And there also enabling the restrictive mode?

Beside this be careful and keep at least one copy of your application without the section access!

- Marcus

Re: Section Access doesn't reduce data

Peony — Tue, 15 Mar 2022 12:50:05 GMT

Hi @elyMalkiAcn Thank you for your help. Unfortunately the reason of the issue not in code, but in document settings.

Re: Section Access doesn't reduce data

Peony — Tue, 15 Mar 2022 12:52:44 GMT

Hi @marcus_sommer Indeed! My bad!😬 I haven't checked document settings before. Thank you for the hint!