topic Section Access with multiple fields in QlikView

Section Access with multiple fields

renem — Tue, 08 Dec 2009 17:34:50 GMT

I am trying to setup security on multiple fields using a matrix defined in Excel:

GROUPNO	DivisionCode	RegionCode	BranchCode
1	*	*	*
2	S	*	*
3	*	GT	*
4	*	*	KZN
5	*	*	JHB
5	*	*	CEN
6	*	GT	*
6	*	*	CPT

My problem is that I cannot get groupno 6 to work security wise as because of the *, I keep getting all Branches returned instead of all branches only for Region GT and then Branch CPT. Any suggestions on how I can accomplish this?

Section Access with multiple fields

Tue, 08 Dec 2009 17:42:14 GMT

GROUPNO	DivisionCode	RegionCode	BranchCode
1	*	*	*
2	S	*	*
3	*	GT	*
4	*	*	KZN
5	*	*	JHB
5	*	*	CEN
6	*	GT	CPT

Section Access with multiple fields

Tue, 08 Dec 2009 17:42:19 GMT

double post

Section Access with multiple fields

renem — Tue, 08 Dec 2009 17:46:31 GMT

Your suggestion doesn't work for me as the branch, CPT is not in the region GT. For Group 6, the user must be able to see all branches in region GT as well as branch CPT, which is not in GT.

Hope this explains it.

Section Access with multiple fields

Tue, 08 Dec 2009 17:53:01 GMT

Assuming CPT branch is in AS region:

GROUPNO	DivisionCode	RegionCode	BranchCode
1	*	*	*
2	S	*	*
3	*	GT	*
4	*	*	KZN
5	*	*	JHB
5	*	*	CEN
6	*	GT	*
6	*	AS	CPT

Section Access with multiple fields

renem — Tue, 08 Dec 2009 18:09:13 GMT

Pls see my attached model. Login with test/1.

The TEST user now has access to all branches because of the * and CPT

Section Access with multiple fields

renem — Tue, 08 Dec 2009 18:10:19 GMT

And this is my spreadsheet

Section Access with multiple fields

Tue, 08 Dec 2009 18:35:26 GMT

yep, you're right. The only solution I could find to this data model is to use detailed info as below

GROUPNO	DivisionCode	RegionCode	BranchCode
1	*	*	*
2	S	*	*
3	*	GT	*
4	*	*	KZN
5	*	*	JHB
5	*	*	CEN
6	*	WC	CPT
6	*	GT	JHB
6	*	GT	CEN