Qlik Community

Ask a Question

QlikView Administration

Discussion Board for collaboration on QlikView Management.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
datanibbler
Champion
Champion

SECTION_ACCESS with OMIT fields


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

0 Replies