topic Re: Controlling what the user sees based on the value of a variable in Integration, Extension & APIs

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

Thu, 10 Sep 2015 17:01:29 GMT

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

sinanozdemir — Thu, 10 Sep 2015 17:55:51 GMT

Hi Tim,

You can utilize section access in QlikView:

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

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

Anonymous — Thu, 10 Sep 2015 18:03:47 GMT

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.

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

sinanozdemir — Thu, 10 Sep 2015 18:42:29 GMT

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?

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

Anonymous — Thu, 10 Sep 2015 19:09:12 GMT

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

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

JonnyPoole — Thu, 10 Sep 2015 21:09:27 GMT

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-data-reduction.htm?Highlight=dynamic data reduction

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

Anonymous — Thu, 10 Sep 2015 21:17:03 GMT

My bad I did not notice it's for qliksense