I'm build an Access Control in a Qlikview Document like:
Star is *;
// SECTION Access;
// SUPER ADMIN LOAD * INLINE [ ACCESS, USERNAME, PASSWORD, MARKER_COMPANIES, MARKER_DATALEVEL,MARKER_SELLTOCUSTOMER, MARKER_EXCLUDINGINVOICENUMBER, MARKER_EXCLUDINGITEMS, MARKER_COMPANY, MARKER_DIVISION, MARKER_SALESDISTRICT, MARKER_CUSTOMER ADMIN, QADMIN, QADMIN, ALL, ALL, ALL, ALL, ALL, ALL, ALL, ALL, ALL ];
LOAD if (ALLDIMENSIONVALUESALLOWED = '-1', 'ADMIN', 'USER') as ACCESS, USERNAME, PASSWORD,
if (REPORTINGALLOWANCEDEMENSION_PK = '1') then (DIMENSIONVALUEALLOWED as MARKER_COMPANY); elseif (REPORTINGALLOWANCEDEMENSION_PK = '3' ) then DIMENSIONVALUEALLOWED as MARKER_DIVISION; elseif (REPORTINGALLOWANCEDEMENSION_PK = '5' ) then DIMENSIONVALUEALLOWED as MARKER_SALESDISTRICT; else DIMENSIONVALUEALLOWED as MARKER_CUSTOMER; ENDIF