7 Replies Latest reply: May 18, 2011 6:30 AM by aiklamha RSS

    Section Access - restricting access based on two columns

      Hi All!

      This question has been asked already, gone unanswered and then archived :) , here: http://community.qlik.com/forums/p/14817/57850.aspx#57850

      Basically, I want users access to be based on two columns not just one.

      e.g.

      Sales data:

       

      IDRegionType1RegionType2
      1AA
      2AA
      3AB
      4BB
      5BA


      User Access:

       

      UserRegionAccess
      PeteA
      AndyB
      RogerA
      RogerB


      I want Pete to have access based on region A, in both columns. So Pete should see records 1,2,3 & 5. Andy should see 3,4 &5, and Roger should see all of them.

      Has anyone had the same need and found an answer yet?

      Help would be much appreciated!

      Jay.