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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
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