Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Section Access and several fields

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?

Tags (1)
1 Solution

Accepted Solutions
Employee
Employee

Re: Section Access and several fields

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

Image2.png

4 Replies
Employee
Employee

Re: Section Access and several fields

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

Not applicable

Re: Section Access and several fields

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"

Employee
Employee

Re: Section Access and several fields

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

Image2.png

Not applicable

Re: Section Access and several fields

Thank you, i understood!

Community Browser