Good morning Qlik Friends!
I am taking over an application as a coworker has left the company that built this report, I am being asked to take over the development/modification of the app and I have run into a roadblock in request and I am unsure if it is even possible to complete.
The application is for our salesforce and there is a Section Access applied in the background (as seen below) that limits the reps view to just sales in their identified territory based on username login.
// set Data Connection
let SectionAccess.DataConnection = 'Server Qlik Upload Files (app_nt_sgueorguiev)/Section Access';
// enable/disable section access
let SectionAccess.Enabled = True();
// set field name to filter
let SectionAccess.FieldName = '[HSM Territory Key]';
// call external section access script
$(Must_Include=[lib://$(SectionAccess.DataConnection)/SectionAccessSalesLyticsHSM.qvs]);
What the request is and what I am needing to do is not only have the app this data, but I also need to be able to have a total roll up number as a company, outside their territory. For example, a page that shows their own individual stats (currently done with section access); then a header on the page that shows the overall company sales. This is where I am running into the issue as the section access limits the data they see to just their territory.
Is there something I can put in a formula that would block the section access? Is there a way I can load a second duplicate database that does not have the section access attached to it? Any thoughts on this would be GREATLY appreciated as this is by far my biggest roadblock in this creation.
Matt
