section access rpoblem

Mon, 06 Aug 2012 14:02:57 GMT

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

Re: section access rpoblem

Wed, 08 Aug 2012 08:41:11 GMT

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

];

topic Re: section access rpoblem in QlikView

section access rpoblem

Re: section access rpoblem