Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Section Access doesn't work

Hi,

I'm trying to implent the section access reduction example from Introduction Document: Introduction to Section Access

I have copy / paste the last example in a hidden script :

Section Access;

LOAD * INLINE [

  ACCESS, USERID, PASSWORD, REGION

  ADMIN, ADMIN, ADMIN, 

  USER, USER1, U1, AFRICA

  USER, USER2, U2, AMERICA

  USER, USER3, U3, ASIA

  USER, USER4, U4, EUROPE

  USER, USER5, U4, AMERICA

  USER, USER5, U5, *

];

Section Application;

SALES:

LOAD * INLINE [

  REGION, PROFIT

  AFRICA, 1000

  AMERICA, 2000

  ASIA, 3000

  EUROPE, 4000

  OCEANIA, 5000

];

When I connect with USER1 / U1 I can see all the profit instead of just Africa as expected.

I have joined the .qvw, the password for hidden script is 123.

Someone has an idea ?

Thank you !!

1 Solution

Accepted Solutions
Gysbert_Wassenaar

Enable the option Initial Data Reduction Based on Section Access and the option Strict Exclusion. You can find these settings on the Opening tab of the document properties window.


talk is cheap, supply exceeds demand

View solution in original post

3 Replies
Gysbert_Wassenaar

Enable the option Initial Data Reduction Based on Section Access and the option Strict Exclusion. You can find these settings on the Opening tab of the document properties window.


talk is cheap, supply exceeds demand
Not applicable
Author

Thank you Gysbert, I knew I was missing something

agigliotti
Partner - Champion
Partner - Champion

Hello Gysbert,

please take a look here:

Re: Strict Exclusion issue in Access Point

Can you help me ?