Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
ruben_moya
Creator
Creator

KPI independent from Section Access

Dear Experts,

I have a dashboard where Managers can see data related only to their stores thanks to Section Access and it works great. 

They have recently asked me to be able to see the percentage of sales that certain store represent within the total of the company. Since they can only see a limited part of the data, I don't really know how to deal with that request.

I've thought about saving that information previously in a qvd file, however, that data needs to be variable according to the selections made by the user.

I've also thought about creating a duplicate of the model  not connected to the main one so it doesn't get affected by the Section Access. Somehow, I'd need create a connection between the fields of both models so, when one field gets selected the other one replicates the action.

I tried to explain myself as well as I could, let me know if you have any idea about how to deal with this scenario.

 

Thanks in advance!

Labels (2)
1 Solution

Accepted Solutions
jwjackso
Specialist III
Specialist III

Create a dummy store that is the aggregation of all stores and grant every manager access to the dummy store.  Use the manager's store/dummy store to get their percentage of sales.

View solution in original post

2 Replies
jwjackso
Specialist III
Specialist III

Create a dummy store that is the aggregation of all stores and grant every manager access to the dummy store.  Use the manager's store/dummy store to get their percentage of sales.

View solution in original post

ruben_moya
Creator
Creator
Author

Hi @jwjackso ,

that's a smart and simple approach, thanks a lot! I will also need to add all the fields they will use to filter de data in the aggregation, let's see if all the extra rows delays the load.

Thanks!