4 Replies Latest reply: Apr 24, 2018 3:14 AM by Sumanta Kumar Mandal RSS

    Section Access

    Louis Lam

      Hi All,


      We have a section access in app,

      There are two fields in section access, one is COMPANY_CODE, the other one is DIVISION_CODE.

      We have set the user sysadmin * in these two fileds so that sysadmin can access all data.


      But the result is some value is filtered out.


      Section Access;






      FROM [lib://DEMO/User list.xlsx]

      (ooxml, embedded labels, table is Access);

      Is there any issue on the script and user list file?


      Best Regards,


        • Re: Section Access
          Nagaian Krishnamoorthy

          The user id has to be in Capitals.

          For the access level specified in your Excel file, you do not need Section Access at all.

          • Re: Section Access
            Rahul Thakkar

            Hi Luis,



            With '*' in COMPANY_CODE and DIVISION_CODE user will be able to see all listed codes for other users. As you are having only ADMIN user currently, you can leave it blank instead of writing '*'.



            For example do check bottom example on this page - https://help.qlik.com/en-US/sense/September2017/Subsystems/Hub/Content/Scripting/Security/manage-security-with-section-access.htm





            • Re: Section Access
              Mark Little

              HI Louis,


              As Rahul suggest this is because of the use of '*', as you would expect this is wild card charater.

              But it will only give you access to any of the COMPANY_CODE or DIVISION_CODE that are used in your section access. One way to get around this to create a dummy user that have all the COMPANY_CODE's and DIVISION_CODE's listed in the access table

              Something like;

              Concatenate Section Access;

              LOAD Distinct

                  'Dummy'  as "USERID",

                  'User'      as  "ACCESS",



              Resident 'Your table'


              you table being where the COMPANY_CODE and DIVISION_CODE are kept in your data. You may have to add more to the script if they are kept on different tables.


              • Re: Section Access
                Sumanta Kumar Mandal

                Hi Louis,


                Instead of writing '*' you can write all the list of company_code and division_code like:


                ACCESS     USERID                         COMPANY_CODE     DIVISION_CODE

                ADMIN     DOMAIN\SYSADMIN          ABC                              EAST

                ADMIN     DOMAIN\SYSADMIN          DEF                              WEST

                ADMIN     DOMAIN\SYSADMIN          XYZ                              NORTH

                ADMIN     DOMAIN\SYSADMIN          PQR                              SOUTH