1 Reply Latest reply: Jun 7, 2018 7:52 AM by Praveen Mallela RSS

    section access with two fields

    Mahitha M

      Hi Experts,

       

      Can any one please help me on Data level security(Section access in qliksense) with Two fields coming from Two different tables.

      Is this correct to apply data security on two fields from two tables? Please confirm.

       

      The table structure is like below.Two tables are linked with ProductID field.

      I have to apply section access on below two fields

      Table1: Product Type/Segment

      Table2: ProductDepartment

       

      I have tried below code to implement. I will get the access on tomorrow to check this practically.

      I am new to this topic. Please let me know am i missed any thing in below code.

       

      Thanks in advance.

       

      Section access source Excel structure

      ---------------------------------------------------------------------------------------------------

      USERID                      ACCESS                   Product Type/Segment                ProductDepartment

      SERVICE\a12456                ADMIN                                               *                                                                  *

      SERVICE\1hy567                USER                                T-Shirt                                                           Clothes 

      SERVICE\8ukjg5                 USER                                 Mobile                                                           Electronics       

      ----------------------------------------------------------------------------------------------------------------------------------

      Section access script

      ------------------------------------------------------------------------------------------------------------------------------------------

      Section access;

      Load

        Upper(USERID)                               as            USERID,

      Upper(ACCESS)                              as           ACCESS,

        Upper([Product Type/Segment])      as           [Product Type/Segment],

        Upper([ProductDepartment])           as           [ProductDepartment];


      Section Application;

      Table1:

      Load

            ProductID,

             Upper([Product Type/Segment])      as           [Product Type/Segment],

           Sales

      From

      ......

       

      Table2:

      Load

         ProductID,

         Upper([ProductDepartment])           as         [ProductDepartment];

         Trades

      From

      ......


        • Re: section access with two fields
          Praveen Mallela

          Hi Mahitha,

           

          i have done somethingf like this

           

          Section access source Excel structure

          ---------------------------------------------------------------------------------------------------

          USERID                      ACCESS                   ProductDepartment                ProductType/Segment

          SERVICE\a12456                ADMIN                                               *                                                                  *

          SERVICE\1hy567                USER                               Cloths                                                             T-Shirts       

          SERVICE\8ukjg5                 USER                                Electronics                                                      Mobile       

          ----------------------------------------------------------------------------------------------------------------------------------

          Section access script

          ------------------------------------------------------------------------------------------------------------------------------------------


          I think this is how it should be , remaining is correct i guess .



          Thanks

          PM