Qlik Community

Qlik Sense Integration, Extensions, & APIs

Discussion board where members can learn more about Integration, Extensions and API’s for Qlik Sense.

Not applicable

Qlik Sence - Restrict view by user role?

How can I effectively structure an application to provide different views for different users?

Overview

Say that I have an application that shows sales data by sales person.  Sales people are grouped into regions, which are overseen by regional managers, who are in turn managed by national sales executives.

I'd like to have an application that lets individual sales people see their data, and how it compares to the average performance for their region.

Regional managers would be able to see the individual statistics for their region, but only aggregate information for other regions.

Sales executives would be able to see everything.

The idea is that we want individuals to see how they--and their direct reports--compare to their peers without disclosing potentially sensitive information to everybody.

Any suggestions for how to structure such an application?

Possible implementation

My first stab at this would be to have an application with three sheets, an individual sheet, a regional sheet and a national sheet.

Then I would somehow lock selected criteria based on the user.  For individuals, we lock Region and Name, for managers we lock region, and for executives we don't lock any criteria.

Is there a straight-forward approach to implementing this using out of the box functionality or perhaps the single integration?  Can we lock criteria but still allow users to select and clear other criteria?

Or does this sound like a use-case for a custom mashup?

2 Replies
thomaslg_wq
Contributor III

Re: Qlik Sence - Restrict view by user role?

Edit : Maybe you should look at a section access solution ?

One Fact_Table_Value ==> detailed information

One or several Aggregated_Values_Tables ==> Aggregated information

One LinkTable ==> Links and Section Access Data Reduction

Not applicable

Re: Qlik Sence - Restrict view by user role?

Edit : Maybe you should look at a section access solution ?

Huh, it seems that I've overlooked this functionality:

https://help.qlik.com/en-US/sense/3.1/Subsystems/Hub/Content/Scripting/Security/manage-security-with...

A Primer on Section Access

This looks promising.  I will look into this and see if section access can implement this use-case.

Thanks!

Community Browser