Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
anat
Contributor

section access based on field

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).

4 Replies
MVP
MVP

Re: section access based on field

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) ;

Highlighted
anat
Contributor

Re: section access based on field

Thanks Petter,

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

balkumarchandel
Valued Contributor II

Re: section access based on field

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

MVP
MVP

Re: section access based on field

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