Qlik Community

QlikView Security & Governance

Discussion Board for collaboration on QlikView Security and Governance.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

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
Highlighted
Contributor
Contributor

Re: Reduce Data with section access without publisher

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
Highlighted
Contributor
Contributor

Re: Reduce Data with section access without publisher

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