Section Access - Multiple Fields

Mon, 23 Jul 2012 06:25:17 GMT

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

topic Section Access - Multiple Fields in QlikView

Section Access - Multiple Fields