Qlik Sence - Restrict view by user role?

Wed, 21 Dec 2016 15:20:48 GMT

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?

Re: Qlik Sence - Restrict view by user role?

thomaslg_wq — Wed, 21 Dec 2016 17:05:51 GMT

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

Re: Qlik Sence - Restrict view by user role?

Wed, 21 Dec 2016 18:28:37 GMT

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-section-access.htm

A Primer on Section Access

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

Thanks!

topic Re: Qlik Sence - Restrict view by user role? in Integration, Extension & APIs

Qlik Sence - Restrict view by user role?

Overview

Possible implementation

Re: Qlik Sence - Restrict view by user role?

Re: Qlik Sence - Restrict view by user role?