I'm managing Section Access using an excel file. For fields that require access control, I apply the following logic: * If a user should have full access to all possible values (no restriction), I assign an asterisk (*) in the relevant cell in the excel file. * If a user should have restricted access, I define the allowed values for the user in the relevant cell in the excel file. For example, users who need to see data for a specific country, and management users who can see all countries.
Now I need to handle more complex scenario: I have several Item fields defined as ItemX, where X is the field number from 1 to 7 (so far). All the fields share the same set of values. My requirements are: * To grant access to all values except one or several values. * To grant access only to values that start or conation a certain character sequence. * I would like to manage these permissions within a single column in the excel file, instead of defining 7 separate columns for each field.
Is this supported in Qlik Sense, and if so, how can I implement it?
Qlik supports it but you must keep in mind, no matter how you set those values in Excel, the values must be listed in Section Access. For example, let's say the set of values you need for User ID 1, for Item1 to 7 are: apple 1 to apple 100.
In Section Access you must list all the values between the range and for all columns:
ACCESS USER.EMAIL ITEM1 ITEM2... ITEM7 USER user1@email.com apple 1 apple 1 apple 1 USER user1@email.com apple 2 apple 2 apple 2 USER user1@email.com apple 3... apple 3... apple 3... USER user1@email.com apple 100 apple 100 apple 100
The challenge is to find a pattern in Excel to easily setup the values that can be easily translated into Qlik. You will probably need to use in Qlik, functions like Subfield, While Loops, etc. There are many ways to solve this problem, for example the "printer page pattern" where you can define range of values plus specific values. Example: 1-7,9,11-25. Meaning: values from 1 to 7, value 9 and values from 11 to 25.
