4 Replies Latest reply: Nov 13, 2013 7:57 AM by Carlos Reyes RSS

    Is there any bug online with sheet restriction access?

    Mikael Cleuziou

      Hello,

       

      I use restriction sheet access with my section application. (Using conditional sum(SH01)>=1 in sheet properties)

       

      My USER X can see only sheet 1;2;3;5 not number 4.

       

      When I am using Qlikview desktop with X identifiants, it works perfectly

      When I am opening my document by the access point in fullweb. X can't see the sheet number 4.

      But if X click on something (filter or a sheet) all the hidden sheets appeared!

       

      I think, I must have an option activated or desactivated. Do you have an idea?

       

      Best regards,

       

      MC

        • Re: Is there any bug online with sheet restriction access?
          Jose Tos

          I think you need to review your section access

           

          Please, copy an example of the security to see how you are using the section access with sheet conditions

           

          regards

            • Re: Is there any bug online with sheet restriction access?
              Mikael Cleuziou

               

              Hello,

               

              Thanks for your answer.

               

              Here you can find my script :

               

              SECTION Access;
              // ****************** Chargement des profils utilisateurs ****************** \\
              SACCESS:
              // Récupération des utilisateurs techniques :
              LOAD DISTINCT
                  
              UPPER(ACCESS) AS ACCESS,
                  
              UPPER(NTNAME) AS NTNAME,
                  
              UPPER(USERID) AS USERID,
                  
              UPPER(PASSWORD) AS PASSWORD,
                  
              UPPER(PRENOM) AS PRENOM,
                  
              UPPER(NOM) AS NOM 
              FROM [$(vPathDataFiles1)BGE - Section Access.xlsx](ooxml, embedded labels, table is BGE_TECHNICAL_USER);

              Concatenate
              //Récupération des utilisateurs BGE :
              LOAD DISTINCT
                  
              UPPER(ACCESS) AS ACCESS,
                  
              UPPER(NTNAME) AS NTNAME,
                  
              UPPER(USERID) AS USERID,
                  
              UPPER(PASSWORD) AS PASSWORD,
                  
              UPPER(PRENOM) AS PRENOM,
                  
              UPPER(NOM) AS NOM
                  
              UPPER(USERGROUP)    AS USERGROUP // Le nom du champ faisant le pont entre la section Access et la section Application

                   // UPPER(OMITGROUP)AS OMITGROUP
              FROM [$(vPathDataFiles1)BGE - Section Access.xlsx](ooxml, embedded labels, table is TABLEAUX_DE_BORD);

              SECTION Application;
              Star is *;
              //// ****************** Chargement des droits d'acces SHEET ****************** \\
              // Aller dans la propriété de la feuille et conditionner l'affichage ie =sum(SH04)>=1

              SHEET:
              LOAD DISTINCT
                  
              UPPER(USERGROUP)      as USERGROUP,             
                  
              SH12,
                  
              SH04,
                  
              SH10,
                  
              SH11,
                  
              SH06,
                
              SH15,
                
              SH16,
                
              SH17,
                
              SH18,
                
              SH19,
                
              SH20,
                
              SH21,
                
              SH22,
                
              SH23,
                
              SH24,
                
              SH25,
                
              SH26,
                
              SH27,
                
              SH30
              FROM [$(vPathDataFiles1)BGE - Section Access.xlsx](ooxml, embedded labels, table is TABLEAUX_DE_BORD_SHEETACCES);

               

              Here is an extract of my excel file.

               

              USERGROUPSH12SH04SH10SH11SH28SH06SH15SH16SH17SH18SH19SH20SH21SH22SH23SH24SH25SH26SH27SH29SH30
              BG75111101111100000000000
              BG77111101111100000000000
              BG91111101111100000000000

               

               

              Then I use conditional show in each sheet : =sum(SH01)>=1

               

               

              It works nice with Qlikview desktop but not by accesspoint.

               

              Thanks for any idea!

               

              Best,

               

              Mikael