Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

section access rpoblem

Dear all,

I've created the following section access:

USERACCESS:

LOAD * INLINE [

    ACCESS, USERID, PASSWORD, FIELD1, FIELD2

    ADMIN, ADMIN,ADMIN, ,

    USER, USER1, U1, 9001,

];

Concatenate

LOAD 'USER' AS ACCESS,

     UPPER(USERCODE) as USERID,

     UPPER(USERPASSWORD) as PASSWORD,

     UPPER(cod1) as FIELD1,

     UPPER(cod2) as FIELD2

     RESIDENT mytable;

// CREAZIONE SECTION ACCESS

SECTION ACCESS;

Load *

Resident USERACCESS;

After the loading, as ADMIN, I see everything. If I close and open the document, as ADMIN I don't see anything. If I open the document as USER1, I see all the information concerning this user. What I'm doing wrong ?

Help please

Thanks in advance

1 Reply
Not applicable

Re: section access rpoblem

what is the reason you load :

// CREAZIONE SECTION ACCESS

SECTION ACCESS;

Load *

Resident USERACCESS;

???

try this : -------------------------------------------

SECTION ACCESS;

USERACCESS:

LOAD * INLINE [

    ACCESS, USERID, PASSWORD, FIELD1, FIELD2

    ADMIN, ADMIN,ADMIN,*,

    USER, USER, USER, 1111,2222

];

Concatenate

LOAD 'USER' AS ACCESS,

     UPPER(USERCODE) as USERID,

     UPPER(USERPASSWORD) as PASSWORD,

     UPPER(cod1) as FIELD1,

     UPPER(cod2) as FIELD2

     RESIDENT mytable;

section Application;

LOAD * INLINE [

    FIELD1, FIELD2

    1, 2

    11, 22

    111, 222

    1111, 2222

];

or this: ---------------------------------------------------------

USERACCESS:

LOAD * INLINE [

    ACCESS, USERID, PASSWORD, FIELD1, FIELD2

    ADMIN, ADMIN,ADMIN,*,

    USER, USER, USER, 1111,2222

];

Concatenate

LOAD 'USER' AS ACCESS,

     UPPER(USERCODE) as USERID,

     UPPER(USERPASSWORD) as PASSWORD,

     UPPER(cod1) as FIELD1,

     UPPER(cod2) as FIELD2

     RESIDENT mytable;

 

//CREAZIONE SECTION ACCESS

SECTION ACCESS;

Load *

Resident USERACCESS;

section Application;

LOAD * INLINE [

    FIELD1, FIELD2

    1, 2

    11, 22

    111, 222

    1111, 2222

];