topic Re: Section Access in QlikView

Section Access

Fanch — Wed, 25 Nov 2020 16:16:04 GMT

Hi everybody,

I want to set up the right access for different users in a Qlikview document.

So, i have created in a hidden script for Section_Access and Section_Application this :

In my table viewer, i have the link for the country.

After loading, i open Qlikview Application and i open qlikview document (by Open or Open in server) and ..... i see alls the country.

What should i do to see only REGION1 and REGION3 ?

Thanks in advance

Re: Section Access

Miguel_Angel_Baeyens — Fri, 06 Mar 2020 10:52:00 GMT

In the Document Properties, is "Strict exclusion" set? (before you enable it, make sure you backup the application).

Using QlikView Desktop, ADMIN may be able to see everything.

Also, when using NTNAME, you will need most likely the form DOMAIN\ACCOUNT as it is returned by the function OSUser() on the QlikView document when you open it.

One easy try is load the same tables without the SECTION lines (commented, for example) and when you select on the field NTNAME for "FANCH" what would you see.

Re: Section Access

Fanch — Fri, 06 Mar 2020 10:57:55 GMT

Hi Miguel,

Thanks for your answers.

My screen picture is just an example. In my original script, i have well the name of domain like this :

NAMEDOMAIN\ADMIN or NAMEDOMAIN\FANCH

Re: Section Access

Fanch — Fri, 06 Mar 2020 14:28:09 GMT

Hi Miguel

Thanks a lot for your answers,

Yeees, it must "In the Document Properties, is "Strict exclusion" set? (before you enable it, make sure you backup the application)."

🍺

Re: Section Access

Brett_Bleess — Thu, 02 Apr 2020 13:27:17 GMT

Adding link to Design Blog post on Section Access that has links to other posts regarding dynamic data reduction too that will likely be helpful to review:

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Section-Access/ba-p/1465766

Regards,
Brett

Re: Section Access

Fanch — Thu, 02 Apr 2020 13:38:15 GMT

Hi everybody,

Finding the solution.

Root cause : Problem with name of account service