Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Partner
Partner

Section Access: Combining Field Reduction and OMIT

I already know that what I want to achieve is not possible using Section Access, but describing the issue with reference to section access seams easiest.

Data Source: HR

Section Access Field Reduction: EmployeeID

Section Access OMIT Field: SalaryAmount

I need to cater for the following scenarios:

  1. UserA logs in a sees Employee1, Employee2 and Employee3. He also sees SalaryAmount for all three employees; - No Problem here
  2. UserB logs in a sees Employee1 and Employee3. He also sees SalaryAmount for Employee1 and Employee3; - No Problem here
  3. UserC logs in a sees Employee1 and Employee3. He does not see SalaryAmount for Employee1 and Employee3; - No Problem here
  4. UserD logs in a sees Employee1, Employee2 and Employee3. He also sees SalaryAmount for ONLY Employee1 and Employee3; - Problem

As I said – I am aware that OMIT will hide the field (or not) for the user on all records or none.

The question: can anyone think of a way to achieve the goal keeping the following in mind:

  1. The Salary Table can have many millions records;
  2. The field need to be hidden ‘n such a way that a self-service user must not be able to get to the values;
1 Solution

Accepted Solutions
tobias_klett
Contributor II

Re: Section Access: Combining Field Reduction and OMIT

Hi Jarno,

forget about the OMIT. What you really want is to reduce the Sales Table differently from the Employee Table. Therefore you need a Link Table for your different Rights like this:

thread_152941.png

Hope this helps.

Regards Tobias

7 Replies
MVP
MVP

Re: Section Access: Combining Field Reduction and OMIT

If you have Publisher, you can reduce the application on bookmark of your choice. The reduced application doesn't contain left out values(literally 'reduced' ).

Partner
Partner

Re: Section Access: Combining Field Reduction and OMIT

Tresesco

The problem I have is not hiding rows, but hiding (OMIT) a field, for certain rows. See scenario 4 in my problem statement.

MVP
MVP

Re: Section Access: Combining Field Reduction and OMIT

Hi

Have a look at these blog posts:

Generic keys

Data Reduction Using Multiple Fields

http://community.qlik.com/blogs/qlikviewdesignblog/2013/11/25/hierarchy-authorization

Basics for complex authorization

They should help you find the correct approach.

HTH

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Partner
Partner

Re: Section Access: Combining Field Reduction and OMIT

jontydkpi

Perhaps I misunderstand your post, but I fail to see how any of those links will help me achieve my scenario 4 in the problem statement?

Let me restate the issue:

How do I show a user a SalaryValue field for certain employees, but not for others. It is not about hiding the row as the employee must still exist in the reduced dataset, but the SalaryValue field must be available on only some of the rows in the users already reduced dataset.

tobias_klett
Contributor II

Re: Section Access: Combining Field Reduction and OMIT

Hi Jarno,

forget about the OMIT. What you really want is to reduce the Sales Table differently from the Employee Table. Therefore you need a Link Table for your different Rights like this:

thread_152941.png

Hope this helps.

Regards Tobias

Partner
Partner

Re: Section Access: Combining Field Reduction and OMIT

Hi Tobias,

Thank you - I will test and report back!

Highlighted
Partner
Partner

Re: Section Access: Combining Field Reduction and OMIT

Hi Tobias,

It works - Thank you!!