Section Access - Multiple Fields

[#1]

Hi there,

I am attempting to apply Section Access to my Qlikview document. 

I need to apply Section Access based on Company and Branch Access.  Some users will see all companies and branches (*), some will see specified companies.  Of those who see specified companies some will see all branches (*), others will see specified branches.

I am able to apply seciton access if limited to CBS_Company as a restriction.  When I attempt to extend Section Access to include CBS_Branch, section Access no longer works for some of the users.  The users that have access to * companies and * braches appear to be working.  Users that have access to specified companies (eg. ximenas), data reduction doesnt link the CBS_Company and CBS_Branch to the BROKERCODEKEY and BRANCHCODEKEY in the Income Table.

The tables are as follows.

COMPANY_BRANCH.CSV

CBS_UserId	CBS_Company	CBS_Branch	NTNAME	ACCESS
sashj	*	*	sashj@austbrokers.com.au	USER
ximenas	ABT	*	XimenaS@aeitransport.com.au	USER
ximenas	AEI	*	XimenaS@aeitransport.com.au	USER
alisonr	CCA	TUG	alisonr@abcentralcoast.com.au	USER

Section_Access:

LOAD   Trim(Upper([ACCESS])) as ACCESS,

            Trim(UPPER(NTNAME)) as NTNAME,

            Trim(Upper(NTNAME)) as USER_KEY

FROM

$(vDataPath)Company_Branch.csv

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

STORE Section_Access into $(vDataPath)Section_Access.qvd (qvd);

drop table Section_Access;

SECTION Access;

SectionAccessTable:

LOAD      [ACCESS],

               NTNAME,

               USER_KEY

FROM

$(vDataPath)Section_Access.qvd

(qvd)

Where 1=1;

Section Application;

Star is *;

User_Section:

LOAD      Trim(Upper(CBS_Company)) as BROKERCODEKEY,

               Trim(Upper(CBS_Branch)) as BRANCHCODEKEY,

               Trim(Upper(NTNAME)) as USER_KEY,

FROM

$(vDataPath)Company_Branch.csv

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

DataTable:

LOAD      Company,

               Company as BrokerCode,

                       Company as BROKERCODEKEY,

               Branch,

               Branch as BRANCHCODEKEY

FROM

$(vDataPath)Income.qvd

(qvd);