Controlling what the user sees based on the value of a variable
I am working with data across several divisions. Each division has their own .xlsx sheet (with identical variables but different values for those variables) I have loaded all of the .xlsx files and concatenated them.
Now what I would like to do is restrict what the user sees based on their Division.
"Division" is a variable within my data. So I want people from Division A to only see the data for rows where "Division" = Division A. I have about 30 divisions each with a different name. Is there a way to do this with access controls within QlikView?
I understand I will need to differentiate their log in information - but just in general how should I go about this?
Re: Controlling what the user sees based on the value of a variable
Hi Tim - loop & reduce isn't there in QLik Sense. I only mention because this posting is in the Qlik Sense community section. You can use section access to provide robust and secure data seggregation by userID or by groupID.
In the Qlik Sense documentation its also referred to as 'Dynamic Data Reduction'. Little history lession: loop and reduce was also called 'Static Data Reduction'. Both are effective and secure means to secure different data profiles for groups or users, but only the former (dynamic) is in Qlik Sense.