The most robust and scalable method to meet the requirements is to integrate the group-level security directly into the Section Access script. By adding the Group field to the Section Access table, a direct link is created between the logged-in user (Sales Account ID) and their assigned Group. When the user opens the app, Section Access automatically reduces the data model, so the Group field will only contain the single value associated with that user. This allows for a simple and efficient conditional expression on each sheet's "Show condition" property (e.g., Only(Group) = 'GroupA') to control its visibility, fulfilling the requirements securely and efficiently.

A. Use the Sales Account ID as a filter on the show/hide condition on the relevant sheet

This approach is not scalable. It would require manually listing all Sales Account IDs for each group within each sheet's show condition, making it difficult to maintain.

B. Use the Group as a filter on the show/hide condition on the relevant sheet

This is a partial solution. While the condition would use the Group field, this option fails to specify how the application will associate the logged-in user with their specific group.

D. Use the OSUser() function within the show/hide condition of the sheets to set the required visibility

The OSUser() function typically returns the service account running the reload, not the end-user accessing the app. Even with the correct function (e.g., UserID()), performing this logic in the UI is inefficient.

---

1. Qlik Sense for Administrators Help - Managing security with section access:

Section: How section access works

Content: The documentation explains that Section Access works by dynamically reducing data based on the user's credentials defined in the load script. By including a field like Group in the Section Access table, Qlik links the user to that data value. This reduced data set is then used throughout the app, making it the authoritative source for security-driven logic, including sheet visibility. This supports adding Group to the Section Access table as the primary step.

Source: Qlik Sense Enterprise on Windows Help, "Managing security with section access".

2. Qlik Sense for Business Analysts Help - Conditional show of sheets, visualizations, dimensions, and measures:

Section: Conditional show of sheets

Content: This official guide details how to use the "Show condition" property for sheets. It states, "You can show or hide a sheet dynamically, depending on a condition... For example, you can use this feature to show a sheet only when certain values are present in your data, or if a user belongs to a certain user group." This directly supports the second part of the correct answer: applying the Group field (which is now filtered by Section Access) to the sheet's show condition.

Source: Qlik Sense Enterprise on Windows Help, "Conditional show of sheets, visualizations, dimensions, and measures".