topic Re: section access based on field in QlikView

section access based on field

anat — Fri, 20 Nov 2020 18:02:30 GMT

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

Re: section access based on field

petter — Wed, 01 Jul 2015 11:53:45 GMT

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

Re: section access based on field

anat — Wed, 01 Jul 2015 12:09:20 GMT

Thanks Petter,

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

Re: section access based on field

Anonymous — Wed, 01 Jul 2015 13:35:39 GMT

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

Re: section access based on field

petter — Wed, 01 Jul 2015 17:43:41 GMT

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