Qlik Community

QlikView Security & Governance

Discussion Board for collaboration on QlikView Security and Governance.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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?

Tags (2)
3 Replies

Re: Section Access Issue/Bug

Show an example of your code

Not applicable

Re: Section Access Issue/Bug

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

Re: Section Access Issue/Bug

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