Qlik Community

Knowledge

Search or browse our knowledge base to find answers to your questions ranging from account questions to troubleshooting error messages. The content is curated and updated by our global Support team

Reloading a QlikView document with Section Access fails on QlikView Server or Publisher

cancel
Showing results for 
Search instead for 
Did you mean: 
Troy_Raney
Digital Support
Digital Support

Reloading a QlikView document with Section Access fails on QlikView Server or Publisher

A QlikView Document (.qvw) with Section Access may fail its reload scheduled by the QlikView Server or Publisher.

 

Environment:

QlikView 

 

Section Access logic works the same way on QlikView Desktop and QlikView Server side. This means we need to provide access to the user executing the reload task and prevent the data from being reduced.

Otherwise, the reload will fail with Access Denied or the application will not include as much data as expected. 

In this example, the QlikView Server service account and the application developer are expected to get all values in field F1. The application end-user on the other hand has limited access to the field F1.

Section Access Script example.png

The application and Section Access works as expected in the QlikView desktop client. The developer gets access to all values in F1 and the user gets limited access in the document. The basic 'deployment' flow in desktop will be as below:

  1. Application is reloaded by Developer
  2. Application is saved to file by Developer
  3. Application is opened by User
  4. Application get reduced based on User's reduction value A
  5. The application shows limited values in F1 to User as expected

 

On the server-side, the workflow will be a bit different, potentially leading to unexpected results for the User.

  1. Application is opened by the Service user
  2. Application is reloaded by the Service user
  3. Data in the QVW file is reduced based on the Service user reduction value
  4. Application is saved to QVW file by the Service user
  5. QVW is distributed


For additional information see QlikView Publisher and Section Access Dynamic Data Reduction Best Practice.

 

 

Related Content:

Qlik Fix: Section Access: Reloading QlikView Documents with Publisher 
QlikView Publisher and Section Access Dynamic Data Reduction Best Practice
Section Access Best Practice Guidance
 

Labels (1)
Version history
Last update:
‎2021-08-10 03:45 AM
Updated by:
Contributors