Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
datagrrl
Creator III
Creator III

OMIT different Fields based on Section Access Reduction Fields

Hello-

I have a Section Access Reduction field. I am basically listing all values in that field for all users, because all of the users can see all records, but depending on the reduction field they may not have access to some column values from that record.

This is my example:

ACCESSUSERIDCOLOROMIT

  ADMIN

ADMIN
USERUSER2

YELLOW

COST
USERUSER2BLUE
USERUSER2REDCOST
USERUSER3YELLOW
USERUSER3BLUECOST
USERUSER3REDCOST
USERUSER3REDVOLUME

The Data has the following fields:

COLORHEIGHTWIDTHCOSTVOLUME

Is this possible? It seemed easy at first, but the method I attempted didn't work.

1 Solution

Accepted Solutions
swuehl
MVP
MVP

I believe OMIT will remove the complete field listed for the user (or multiple fields if you are listing multiple in multiple section access lines). It will not remove fields values, e.g values of field COST only for records where COLOR equals YELLOW or RED (see USER2).

Is this what you are trying to achieve?

View solution in original post

2 Replies
swuehl
MVP
MVP

I believe OMIT will remove the complete field listed for the user (or multiple fields if you are listing multiple in multiple section access lines). It will not remove fields values, e.g values of field COST only for records where COLOR equals YELLOW or RED (see USER2).

Is this what you are trying to achieve?

datagrrl
Creator III
Creator III
Author

Yes, that is exactly what I am trying to do.