section access based on field

[anat]

SECTION ACCESS;

Access,  UserID,  Password,  CostCenter

USER,  USER,  USER,  *

ADMIN,  ADMIN,  ADMIN,  *

USER,  JOHN,  JOHN,  A

USER,  MARY,  MARY,  B

USER,  PETER,  PETER,  C

ADMIN,  SIMON,  SIMON,  A

Cost Centers values will change  from USER to USER<MARY costsenter=B later it will change>  or may be add extra cost centers to USERS,

after some time  Cost Center X and Y will comes under   USER JOHN(able to view A,X,Y)

how to implement SECTION ACCESS by passing FILED (without hard coding CostCenters).

[petter]

You can use a LOAD to maintain the connection between USERID and CostCenter.

SECTION ACCESS;

Users:

LOAD * INLINE[

ACCESS, USERID, PASSWORD

USER, USER, USER

ADMIN, ADMIN, ADMIN

USER, JOHN, JOHN

USER, MARY, MARY

];

UsersCostCenters:

LOAD

     USERID,

     CostCenter

FROM [USER-COSTCENTER.TXT] (txt) ;

[anat]

Thanks Petter,

is it possible to link with source  CostCenter field <this is coming from source>,instead of creating separate txt/excel file.

[Anonymous]

Hi Ananth ,

Peter is given you a example. You can use your source system as well if you have

USERID,

     CostCenter

in source system.

Thanks

BKC

[petter]

QlikView doesn't care much where the data of tables and fields come from. So any valid LOAD statement will do. Just remember that the SYSTEM FIELDS has to be in uppercase - you can't have mixed or lower case on any of this fields. The system fields are ACCESS, USERID, PASSWORD etc ....