SECTION_ACCESS with OMIT fields

datanibbler — Mon, 26 Jan 2026 18:19:17 GMT

Hi,

in my personell_app, I would like to introduce something new:

- There should be names, but

- ONLY for the HR department and myself

=> For all other users, the names should not be loaded into the DataModel.

=> In principle, this should be easy: In my SA (which I construct from two parts, a short inline_table and a LOAD from an excel file), I have introduced a new field, OMIT.

=> As I have eight name_fields (I had to work with alias names a few times to avoid synthetic keys), every user has eight lines in the
Excel field.

<=> It works but for the OMIT fields - those remain visible. I have only tested with one user (from the Excel list) and one chart (that is, two name_fields), but those are visible.

Can anybody tell me what I'm doing wrong here?`

I paste here the code for both parts of the SA. There must be something wrong there.

Oh - I have checked that "restrict data based on ..." in the document_properties, and the one below ("restrictive mode") too.

SA_temp:

LOAD * INLINE [
    ACCESS, NTNAME, OMIT
    ADMIN, [domain]\friedrich.hofmann,
    USER, [domain]\SYNCREON\rgb1.hr,
];
// Zunächst werden hier alle anderen User aus einer Excel-Liste angehängt

Concatenate
LOAD
     ACCESS,
     NTNAME,
     OMIT
FROM
[Users_with_limited_access_rights_b.xls
(biff, embedded labels, table is [Sheet1$]);
// Jetzt können wir diese Gesamttabelle RESIDENT laden und für den SA verwenden
Section Access;
LOAD
    ACCESS,
    NTNAME,
    OMIT
RESIDENT SA_temp
;

DROP TABLE SA_temp;

(attached is the Excel file for the second part of the SA)

Thanks a lot!

Best regards,

DataNibbler

topic SECTION_ACCESS with OMIT fields in QlikView

SECTION_ACCESS with OMIT fields