topic Multiple Reduction Fields in Section Access in QlikView

Multiple Reduction Fields in Section Access

Tue, 27 Oct 2009 23:28:59 GMT

I need to be able to do data reduction on section access information for 2 reduction fields, salesperson and branch.

Each user (non-ADMIN) will only have information for one of the 2 fields, I don't want to restrict the data on the other field. If the user is a salesperson I want all the information for that salesperson. If the user is a branch manager I want only the information for that branch but all the salespeople who sold at that branch.

The two fields are linked in a hierarchy. The sales are recorded to a salesperson but not to a branch because the branch is picked up from the hierarchy as below.

BRANCH SALESPERSON

1 1

1 2

2 3

2 4

I bring in the section access from a table in Excel (attached):

I tried leaving out the wildcards, this didn't work at all, no user could open document. With the table as it is Users A-D can open document correctly but users E & F can't.

Any ideas on how to fix this? I did include "Star is *;"

Multiple Reduction Fields in Section Access

Mon, 02 Aug 2010 14:33:30 GMT

Did you ever get a response to this? It seems like a common scenario to have a hierarchy for section access with varying levels of access/reduction.

Multiple Reduction Fields in Section Access

Mon, 02 Aug 2010 20:33:18 GMT

You have to set up separate access tables for each level in the hierarchy

Multiple Reduction Fields in Section Access

Mon, 02 Aug 2010 21:08:58 GMT

Would you happen to have an example of what this would look like in the QV code?

Multiple Reduction Fields in Section Access

Wed, 04 Aug 2010 10:40:38 GMT

set

zModel = "**Your security spreadsheet name**";

Section

Access;

//$(Include=security.qvs)

USERS:

LOAD

LEVEL

as ACCESS

'*'

as USERID

'*'

as PASSWORD

USER

as NTNAME

GROUPNO

as GROUPNO1

GROUPNO

as GROUPNO2

GROUPNO

as GROUPNO3

GROUPNO

GROUPNO4

FROM

[$(zModel).xlsx]

(

ooxml, embedded labels, table is USERLIST)

;

Section

Application;

star

is *;

let

z1=1;

for

each z in 'Level1','Level2','Level3'

"SECURITY$(z)":

LOAD

GROUPNO

as GROUPNO$(z1),

$(z)

_NAME

FROM

[$(zModel).xlsx]

(

ooxml, embedded labels, table is GROUPS);

let

z1 = z1 + 1;