Discussion Board for collaboration on QlikView Security and Governance.
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, ORIGINADMIN, DOMAINE\Qlik.ServUSER, DOMAINE\Y.TOTO,US];section application;
Country:Load * Inline [ORIGIN, CountryFR, FranceJP, JaponUS, USADE, 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 ?
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