Dynamic Data Reduction based on Section Access (multiple data values from a single field)
Hi
I am trying to implement data level security in my qlikview application.
The users can have different priviledges depending upon their business profiles and roles. The data security rules are defined per user.
Example:
ACCESS NTNAME Rule
USER userA Consumer Products
USER userB Retail, Consumer Products
USER userC Real Estate
USER userD Industrial, Retail
USER userE Industrial
.........
........
.......
In the data model, the rules for entitlements are based on data values (Real Estate, Retail, Industrial, Energy...) from a single Field (INDUSTRY).
A user may be entitled to a specific industry, another user may have entitlements for three industries. The possible number of such combination rules is not currently defined and I am not is a position to create separate flags in my data for the different buckets of data values which are possible.
I know, OMITFIELD allows multiple fields to be mentioned as comma separated values within section access to restrict fields from being shown per user. Is there a similar logic which can be implemented to entitle users to view multiple data values from a single field.
Kindly let me know if anybody on the forum has implemented something like this, or any other implementation which you can think of.
Hi Sparur, Your method works for having 1 value in the INDUSTRY field. Is there a way where you can have it not filter by INDUSTRY for a user?
Here is what I am trying to do:
GROUP INDUSTRY SUBINDUSTRY
1 Consumer Products Product A
2 Retail <I do not want to filter here by SUBINDUSTRY>
Is there a way for in group 2 to not filter the SUBINDUSTRY? If I leave it blank then when the data is reduced there are no values in the SUBINDUSTRY field.
I don't know if you still need an answer for this, but i'll post it anyway for other people who might have the same problem. I was looking for the answer to this exact same question and discovered the solution by accident.
As far as i've found: listing multiple values seperated by comma is not possible. You need to ad a line to your table for each value the user can see. for your example, the table you want to load as your section access will be:
