6 Replies Latest reply: Sep 10, 2015 5:17 PM by Rupesh Bharadwaj RSS

    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?