Controlling what the user sees based on the value of a variable

[#1]

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?

[sinanozdemir]

Hi Tim,

You can utilize section access in QlikView:

Although, the field name(s) should be all upper cases as well as the data.

[Anonymous]

You can use loop and reduce functionality. It will create as many applications as the number of divisions and limit the data for each division in the applications.

[sinanozdemir]

Hey QlikRajan,

Probably, I am not understanding, but how efficient this is? If the application is deployed to the server, wouldn't this method cause a bottleneck?

[Anonymous]

This method can be used using QMC and I don't see any bottleneck

[JonnyPoole]

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.

http://help.qlik.com/sense/2.0/en-US/online/#../Subsystems/Hub/Content/Scripting/Security/dynamic-da... data reduction

[Anonymous]

My bad I did not notice it's for qliksense