Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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).
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) ;
Thanks Petter,
is it possible to link with source CostCenter field <this is coming from source>,instead of creating separate txt/excel file.
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
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 ....