topic Re: Section Access and several fields in QlikView

Section Access and several fields

Mon, 18 Mar 2013 15:16:43 GMT

Hello!

I have the following problem with section access.

I have 6 users:

User1

User2

User3

User4

User5

User6

User1 must see field name SALESMAN and Field value "user1"

User2 must see field name SALESMAN and Field value "user2"

User3 must see field name MANAGER and Field value "user3"

User1 must see field name MANAGER and Field value "user4"

User1 must see field name EMPLOYEE and Field value "user5"

User1 must see field name EMPLOYEE and Field value "user6"

Must i do 3 "section access" in my QV document for fieldnames SALESMAN, MANAGER , EMPLOYEE ?

Can any help me please?

Re: Section Access and several fields

hic — Mon, 18 Mar 2013 16:19:20 GMT

You should not do 3 Section Access.

But what you should do depends of what the users should see. Should User1 see the intersection between SALESMAN='user1' and MANAGER='user1' and EMPLOYEE='user1'? Or should he see the union between the three?

My guess is that it is the union. If so, then it is a complex problem for which you need Generic Keys. Start by reading the blog post about complex authorization. Then the Technical Brief about Generic Keys.

HIC

Re: Section Access and several fields

Mon, 18 Mar 2013 17:18:46 GMT

I'm sorry, it was mistake.

User1 must see field name SALESMAN and Field value "user1"

User2 must see field name SALESMAN and Field value "user2"

User3 must see field name MANAGER and Field value "user3"

User4 must see field name MANAGER and Field value "user4"

User5 must see field name EMPLOYEE and Field value "user5"

User6 must see field name EMPLOYEE and Field value "user6"

Re: Section Access and several fields

hic — Mon, 18 Mar 2013 17:28:43 GMT

So, you want User1 to have a restriction in SALESMAN but no restriction in MANAGER or EMPLOYEE? I.e. an authorization table like the one below?

Then you should definitely read the linked posts in my previous response.

HIC

Re: Section Access and several fields

Mon, 18 Mar 2013 19:04:43 GMT

Thank you, i understood!