8 Replies Latest reply: Jul 6, 2017 11:12 AM by Helga Ventura RSS

    Qlik Sense Section Access is not working properly

    Helga Ventura

      Hi to all,

       

      I'm facing a problem with section access that i cannot resolve/ understand

       

      I've two sources of data: DW (sales data) and an excel file (targets). My user QlikAdmin, can see all sales data but the data from excel is not appearing.

      In my data model, i had already created an autorization key field to connect to my section access script:

       

      Section Access;

      SecurityTable:

      LOAD * INLINE [

      ACCESS, USERID, YEAR, MONTH, COD_EMPRESA, COD_SA, COD_PROS, COD_TECNICO, AUTHORIZATIONKEY, COD_CLIENT

      ADMIN, SRVBIQLIK\QLIKADMIN, *, *, *, *, *, *, *, *

      ];

       

      Concatenate

      Load *

      Resident TabSA;

       

      Section Application;

      Drop Table TabSA;

       

      So, my user QlikAdmin as an administrator with asterisk in every fields is not able to see all data.

      What can i do to solve this problem?

       

      Hope someone can help me soon,

       

      Regards,

      Helga

        • Re: Qlik Sense Section Access is not working properly
          Antonio Mancini

          Hi Helga,

          Administrator is able to see only fields who Users are seeing , not all data.

          Try to remove * from Administrator row (like Null Field).

          Regards,

          Antonio

          • Re: Qlik Sense Section Access is not working properly
            Nicky Maehler

            Hi Helga,

             

            Section Access with the Asterix will work however it only works on the access provided to the other users.

            Here is an example:

             

            Section Access;
            LOAD * INLINE [
                ACCESS, USERID, PASSWORD, %FLIGHTTYPE
                ADMIN, ADMIN, ADMIN123, *
                USER, DF, DF123, DOMESTIC_FOREIGN
                USER, DU, DU123, DOMESTIC_US
                USER, IF, DIF123, INTERNATIONAL_FOREIGN
            ];
            Section Application;

            LOAD * INLINE [
            %FLIGHTTYPE, Flight Type
                DOMESTIC_FOREIGN,"Domestic, Foreign Carriers"
                DOMESTIC_US, "Domestic, US Carriers Only"
                INTERNATIONAL_FOREIGN,"International, Foreign Carriers"
                INTERNATIONAL_US,"International, US Carriers Only"
            ];

             

            Notice that Admin is assigned * to the %FLIGHTTYPE field.

            There are 3 other users with the values of DOMESTIC_FOREIGN, DOMESTIC_US and INTERNATIONAL_FOREIGN for the %FLIGHTTYPE field.

             

            Notice in the INLINE table below there are actually 4 different values available for the %FLIGHTTYPE field therefore INTERNATIONAL_US has not been assigned to anyone.

            You normally think that the assign * would actually include all 4 different %FLIGHTTYPE values however it does not. The asterix only applies to the 3 that have been assigned to users.

             

            In order to get around this you need to change the access to include an additional line for the Admin user and assign the value of INTERNATIONAL_US to the %FLIGHTTYPE field.

             

            Section Access;
            LOAD * INLINE [
                ACCESS, USERID, PASSWORD, %FLIGHTTYPE
                ADMIN, ADMIN, ADMIN123, *
                ADMIN, ADMIN, ADMIN123, INTERNATIONAL_US
                USER, DF, DF123, DOMESTIC_FOREIGN
                USER, DU, DU123, DOMESTIC_US
                USER, IF, DIF123, INTERNATIONAL_FOREIGN
            ];
            Section Application;

            LOAD * INLINE [
            %FLIGHTTYPE, Flight Type
                DOMESTIC_FOREIGN,"Domestic, Foreign Carriers"
                DOMESTIC_US, "Domestic, US Carriers Only"
                INTERNATIONAL_FOREIGN,"International, Foreign Carriers"
                INTERNATIONAL_US,"International, US Carriers Only"
            ];

             

            Hope that helps,

            Nicky