topic Re: Section Access With NTName in QlikView

Section Access With NTName

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

I am implementing the Section Access with NTNAME.

I reload the document on my desktop and saved and then deployed.

When other user (of my team) access the document from access point he see the same data which I have saved on my machine instead of data which is applicable to him.

In qlikview do we need to reload/refresh qlikview document each time before each user access the same document in which section access is implemented with NTANME?

How does Section Access works? I do not want to reload/refresh qlikview document before each user access the dashboard to see data related to the user.

Re: Section Access With NTName

krishnacbe — Wed, 13 Sep 2017 16:38:18 GMT

Hi,

Check whether you have enabled Document Properties -> Opening Tab -> Initial Data Reduction Based on Section Access and Strict Exclusion

Re: Section Access With NTName

Anonymous — Wed, 13 Sep 2017 17:24:58 GMT

I have already done this setting.

Re: Section Access With NTName

krishnacbe — Wed, 13 Sep 2017 17:48:05 GMT

Can you Share the Section Access Script to check the issue

Re: Section Access With NTName

krishnacbe — Wed, 13 Sep 2017 17:48:31 GMT

With some sample data

Re: Section Access With NTName

Anonymous — Fri, 15 Sep 2017 19:28:45 GMT

Following is my code

SECTION ACCESS;

Config2:

SQL SELECT ACCESS,NTNAME,REGION FROM [tb_access];

SECTION APPLICATION;

Data1:

SQL SELECT [OrderID] as OrdID

,[CustomerID]

,[OrderDate] as OrdDate

,[EmployeeID] AS EMPLOYEEID

,[RequiredDate]

,[ShippedDate]

,[ShipVia]

,[Freight]

,[ShipName]

,[ShipAddress]

,[ShipCity]

,[ShipRegion]

,[ShipPostalCode]

,UPPER([ShipCountry]) AS REGION

FROM Orders;

----------

Access table data

ACCESS, NTNAME, REGION

ADMIN, ADMIN

USER, USER1, INDIA

USER, USER2, UK

USER, USER1, US

USER, USER3, HONGKONG

Re: Section Access With NTName

Peter_Cammaert — Sat, 16 Sep 2017 11:28:00 GMT

Check whether Section Access is really enabled in your document in the AP. For example, can a user that is not listed in the Section Access table open the document in the AccessPoint or not?