Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. $300 savings extended to February 9th Learn More
Highlighted
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
MVP & Luminary
MVP & Luminary

Re: Section Access doesn't work

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
MVP & Luminary
MVP & Luminary

Re: Section Access doesn't work

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

Not applicable

Re: Section Access doesn't work

Thank you Gysbert, I knew I was missing something

Partner
Partner

Re: Section Access doesn't work

Hello Gysbert,

please take a look here:

Re: Strict Exclusion issue in Access Point

Can you help me ?