topic Section Access Issue/Bug in QlikView

Section Access Issue/Bug

Mon, 26 Jan 2026 18:19:17 GMT

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?

Re: Section Access Issue/Bug

nicolett_yuri — Thu, 03 Oct 2013 22:27:07 GMT

Show an example of your code

Re: Section Access Issue/Bug

Fri, 04 Oct 2013 13:54:47 GMT

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

Peter_Cammaert — Fri, 04 Oct 2013 14:49:35 GMT

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