Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor
Contributor

Section Access With NTName

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.

6 Replies
Partner
Partner

Hi,

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

Contributor
Contributor

I have already done this setting.

Partner
Partner

Can you Share the Section Access Script to check the issue

Partner
Partner

With some sample data

Contributor
Contributor

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

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?