Qlik Community

Qlik Sense Integration, Extensions, & APIs

Discussion board where members can learn more about Integration, Extensions and API’s for Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

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?

Tags (1)
6 Replies
sinanozdemir
Valued Contributor III

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

Hi Tim,

You can utilize section access in QlikView:

Capture.PNG

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

qlikrajan
Contributor III

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

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
Valued Contributor III

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

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?

qlikrajan
Contributor III

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

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

Employee
Employee

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.

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

qlikrajan
Contributor III

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

My bad I did not notice it's for qliksense

Community Browser