1 Reply Latest reply: Apr 16, 2018 11:57 AM by Lauri Scharf RSS

    how to give section access by two fields ?

    gaurav gopale

      Hi all

       

      I have an qliksense application, i have to give section access to the users

       

      I want to give some users access by category and some users by sector.


      for eg 

      i want to give 40 users access by category , and 60 users access by sector


      How should i create section access file for this application ?

       

      Can anyone help me in this ?

       

       

       

       

      Thanks in advance

        • Re: how to give section access by two fields ?
          Lauri Scharf

          Someone else may have a better idea, but here's what I might do:

           

          Section Access:

          users:

          Load * Inline [

          USER, ACCESS, CATEGORY, SECTOR, OMIT

          JOE, USER, 1, 1,

          MATT, USER 1, 2,

          SUE, USER, 2, 2,

          ];

           

          Section Application:

          Categories:

          Load CATEGORY, [all other fields]

          From ...;

           

          Sectors:

          Load SECTOR, [all other fields]

          From ...;

           

          Notes about this:

          • I have only put one field into a section access table; hopefully putting in two (CATEGORY and SECTOR) works. If not, then create a new field that is the key; it could be CATEGORY & '_' & SECTOR As csKey, and load it into the users table as well as Categories and Sectors tables.
          • Be sure to capitalize all section access fields and values, if string.