Reduce Data with section access without publisher

[yannick_tallade]

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 ?

[yannick_tallade · Accepted solution]

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