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

[Troy_Raney]

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.

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