Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
ali_hijazi
Partner - Master II
Partner - Master II

loading users of active directory into table of section access

can I load the users of the active directory into section access table?

how can I restrict or reduce data for each user?

I mean out of the users some are allowed to see data for a specific country others are allowed to see data for other countries

while some may see everything

I can walk on water when it freezes
1 Reply
mihaiturturica
Partner - Contributor III
Partner - Contributor III

Hi Ali,

Yes you can put users of the active directory into section access table.

Example:

//=====================

Star is *;

Section Access;

LOAD * INLINE [

    ACCESS, NTNAME, REDUCE

ADMIN, DOMAIN/ADMIN, ALL

USER, DOMAIN/USER1, FRANCE

];

Section Application;

LOAD * INLINE [

REDUCE, COUNTRY

ALL, *

FRANCE, FRANCE

];

//====================

where COUNTRY is the field for reduce

Then in application, Settings => Document properties => Open => and mark "Initial Data Reduction Based on Section Access" and "Strict Exclusion"

Best regards,

Mihai