Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW

"Access denied" or incorrect data set when opening a document with a Section Access-based reduction

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
Sonja_Bauernfeind
Digital Support
Digital Support

"Access denied" or incorrect data set when opening a document with a Section Access-based reduction

Last Update:

Jun 23, 2021 9:11:22 AM

Updated By:

Sonja_Bauernfeind

Created date:

Mar 5, 2012 10:17:28 AM

Attachments

When opening a document with a section access-based data reduction you

  • receive the error "Access denied" despite using correct credentials
  • get access to the full data set
  • get access to an incorrect data set, i.e. missing values

If the document has been distributed using Publisher - or opened using Desktop and saved without reloading - it is likely an issue with the design of the section access.

 

Environment:

Qlik Sense Enterprise on Windows 
QlikView 

 

The attached document illustrates how you can design your section access to handle both distributing the document without any reduction taking place and to give an actual user full access to the data.

  • Open the document using QlikView Desktop
  • Login with the username "admin" (no password)
  • Review the script and comments

When you distribute a document using Publisher (or open and save it with the Desktop client) there will be a reduction made for the user who is running the distribution. That means that all values in the section application that doesn't match the reduction value will be lost. The result will be that other users are not able to open the document or get access to an incorrect data set.

If no value is found that matches the reduction value, no selection will be made and with admin access no reduction will take place either. This is the desired behaviour when performing a distribution. Note that a user set up this way will not be able to open the document from the QlikView Server as the admin access level isn't respected in this scenario.

 

Labels (1)
Contributors
Version history
Last update:
‎2021-06-23 09:11 AM
Updated by: