topic Re: Section Access doesn't work in QlikView

Section Access doesn't work

Fri, 24 Jan 2014 16:50:45 GMT

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 !!

Re: Section Access doesn't work

Gysbert_Wassenaar — Fri, 24 Jan 2014 16:59:46 GMT

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.

Re: Section Access doesn't work

Fri, 24 Jan 2014 17:03:08 GMT

Thank you Gysbert, I knew I was missing something

Re: Section Access doesn't work

agigliotti — Thu, 30 Jan 2014 14:25:11 GMT

Hello Gysbert,

please take a look here:

Re: Strict Exclusion issue in Access Point

Can you help me ?