Qlik Community

QlikView Administration

Discussion Board for collaboration on QlikView Management.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
yannick_tallade
Contributor II
Contributor II

Reduce Data with section access without publisher

Hello ALL,

we have one report qlik and we need to reduce data base on section access (we don'r have publisher here). We want when user Y.TOTO logs into report, he can see only US data.

I made this.

Section Access;
LOAD * inline [
ACCESS, NTNAME, ORIGIN
ADMIN, DOMAINE\Qlik.Serv
USER, DOMAINE\Y.TOTO,US
];
section application;

Country:
Load * Inline [ORIGIN, Country
FR, France
JP, Japon
US, USA
DE, Allemange
](Delimiter is ',');

 

But when user Y.TOTO logs into report, nothing happen and he can see all country.

NB: ORIGIN is present in the fact table.

 

Can somebody help me please ?

1 Solution

Accepted Solutions
yannick_tallade
Contributor II
Contributor II
Author

Oh, I found solution. I have forget to enable both 'Initial data reduction based on Section Access' and 'Strict Exclusion

View solution in original post

1 Reply
yannick_tallade
Contributor II
Contributor II
Author

Oh, I found solution. I have forget to enable both 'Initial data reduction based on Section Access' and 'Strict Exclusion

View solution in original post