Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Section Access Issue/Bug

Hi,

We have Section Access implemented in our application based on a reduction field which is a compound key based on multiple fields.

Many users have access to the app and based on the security key the users sees his data. This was working as expected till some users started missing some data. Randomly they don't see some data and it gets fixed in the next reload. Any idea on what the issue is?

3 Replies
nicolett_yuri

Show an example of your code

Not applicable
Author

The section access code is like this:

 

Section Access;

LOAD

ACCESS,
NTNAME,
[SECURITY KEY]
FROM
Security.qvd]
(
qvd)
Where

1=1;

The security .qvd contains all the Security keys formed using Autonumnberhah128(field1,field2,field3,field4,field5)

All these NTNames have access 'User'

there also Admins who have full access *

We haven't enabled strict exclusion as it causes some issues for Admin users

Peter_Cammaert
Partner - Champion III
Partner - Champion III

A good approach to figure out what is being reduced too far for certain users, or is just missing altogether:

  • Disable "Data Reduction based on..."
  • Put the Section Access; statement in comments.
  • Reload in your desktop (not on the server).
  • Put a list box on a sheet that displays NTNAME.
  • From this listbox, select a value that corresponds to a user with data problems.
  • Follow all links and associations.

Is the required data present? Does everything turn out to be ok? Or are there problems with those same associations?

Peter