7 Replies Latest reply: Dec 30, 2015 8:27 AM by Joanna Seldon RSS

    section access qlik sense

    Joanna Seldon

      Hiya

       

      this is in my main data table

       

      Main:

       

          type,

          UPPER(type) AS TYPE_SA,

          Board,

          UPPER(Board) AS BOARD_SA,

          "Status",

          UPPER("Status") AS STATUS_SA,

          UPPER(Board) & '|' & UPPER("Status") AS BOARD_STATUS_SA,

          UPPER(Board) & '|' & UPPER("type") AS BOARD_TYPE_SA,

       

      Section access

       

      MyBridge:
      LOAD
      [BOARD_SA] &'|'& [STATUS_SA] AS BOARD_STATUS_SA,
      [BOARD_SA] &'|'& [STATUS_SA] AS BRIDGEID_SA
      RESIDENT Main;

      LOAD
      [BOARD_SA] &'|'& [STATUS_SA] AS BOARD_STATUS_SA,
          [BOARD_SA] &'|<ANY>' AS BRIDGEID_SA
      RESIDENT Main;

      LOAD
      [BOARD_SA] &'|'& [STATUS_SA] AS BOARD_STATUS_SA,
          '<ANY>|'& [STATUS_SA] AS BRIDGEID_SA
      RESIDENT Main;

      LOAD
      [BOARD_SA] &'|'& [STATUS_SA] AS BOARD_STATUS_SA,
          '<ANY>|<ANY>' AS BRIDGEID_SA
      RESIDENT Main;

       

      ******* This code works up to here


      LOAD
      [BOARD_SA] &'|'& [TYPE_SA] AS BOARD_TYPE_SA,
      [BOARD_SA] &'|'& [TYPE_SA] AS BRIDGEID_SA
      RESIDENT Main;

       

      The section access works...however I have an issue here this keeps making a circular reference...how can this be prevented?

       

      please help

        • Re: section access qlik sense
          Jordi Arenas

          Hi,

           

          Delete the last section

           

          LOAD

          [BOARD_SA] &'|'& [TYPE_SA] AS BOARD_TYPE_SA,

          [BOARD_SA] &'|'& [TYPE_SA] AS BRIDGEID_SA

          RESIDENT Main;


          Regards,

          • Re: section access qlik sense
            Sangram Reddy

            Hi Joanna,

             

            the load statement

             

            LOAD

            [BOARD_SA] &'|'& [TYPE_SA] AS BOARD_TYPE_SA,

            [BOARD_SA] &'|'& [TYPE_SA] AS BRIDGEID_SA

            RESIDENT Main;


            creates an another tables, instead cant you make the table "My Bridge" have 3 columns and concatenate this data into the same table?

            • Re: section access qlik sense
              Jordi Arenas

              Hi Joanna,

               

              Sorry I don't understand what's your porpouse in Section Access but maybe this link can help you.

               

              Look at dynamic

              https://help.qlik.com/sense/1.1/en-US/online/Subsystems/Hub/Content/Scripting/Security/ManagingSecurityWithSectionAccess.htm

               

              And if you like you can make a prove (to look for circular reference).

               

              In your Original script change the last sequence for this one:

               

              LOAD

              [BOARD_SA] &'|'& [TYPE_SA] AS BOARD_TYPE_SA_2,

              [BOARD_SA] &'|'& [TYPE_SA] AS BRIDGEID_SA

              RESIDENT Main;


              Regards

                • Re: section access qlik sense
                  Joanna Seldon

                  Hiya

                   

                  I changed it as above, it runs, but it does not work, all filter panes on sheets are, greyed out.

                   

                  so I updated the data below

                   

                  Main:

                   

                      type,

                      UPPER(type) AS TYPE_SA,

                      Board,

                      UPPER(Board) AS BOARD_SA,

                      "Status",

                      UPPER("Status") AS STATUS_SA,

                      UPPER(Board) & '|' & UPPER("Status") AS BOARD_STATUS_SA,

                      UPPER(Board) & '|' & UPPER("type") AS BOARD_TYPE_SA_2,

                   

                  it works again, but circular reference returns

                   

                  please help


                    • Re: section access qlik sense
                      Jordi Arenas

                      Hi Joanna,

                       

                      Yo have 1 or more fields with the same Name in the 3 tables. Review it.

                       

                      In the other comment I proposed this one for your understanding of circular reference:

                       

                      Main:

                      LOAD

                           type,

                          UPPER(type) AS TYPE_SA,

                          Board,

                          UPPER(Board) AS BOARD_SA,

                          "Status",

                          UPPER("Status") AS STATUS_SA,

                          UPPER(Board) & '|' & UPPER("Status") AS BOARD_STATUS_SA,

                          UPPER(Board) & '|' & UPPER("type") AS BOARD_TYPE_SA

                      FROM [lib://C/listadoConsumos.xlsx]

                      (ooxml, embedded labels, header is 1 lines, table is Sheet0);

                       

                       

                      MyBridge:

                      LOAD

                      [BOARD_SA] &'|'& [STATUS_SA] AS BOARD_STATUS_SA,

                      [BOARD_SA] &'|'& [STATUS_SA] AS BRIDGEID_SA

                      RESIDENT Main;

                      LOAD

                      [BOARD_SA] &'|'& [STATUS_SA] AS BOARD_STATUS_SA,

                          [BOARD_SA] &'|<ANY>' AS BRIDGEID_SA

                      RESIDENT Main;

                      LOAD

                      [BOARD_SA] &'|'& [STATUS_SA] AS BOARD_STATUS_SA,

                          '<ANY>|'& [STATUS_SA] AS BRIDGEID_SA

                      RESIDENT Main;

                      LOAD

                      [BOARD_SA] &'|'& [STATUS_SA] AS BOARD_STATUS_SA,

                          '<ANY>|<ANY>' AS BRIDGEID_SA

                      RESIDENT Main;

                       

                      //******* This code works up to here

                       

                       

                        LOAD

                         [BOARD_SA] &'|'& [TYPE_SA] AS BOARD_TYPE_SA_2,

                         [BOARD_SA] &'|'& [TYPE_SA] AS BRIDGEID_SA

                         RESIDENT Main;


                      Regards

                        • Re: section access qlik sense
                          Joanna Seldon

                          Hiya

                           

                          I have tried renaming tables and still have no joy, only when I get a circular reference it works.

                           

                          here is my security table

                           

                          Security:

                           

                          LOAD * INLINE [

                          SA_LINK,BRIDGEID_SA

                          ALL,*    

                          GROUP1,NORTH|<ANY>

                          GROUP2,<ANY>|ORDERACTIVE

                          GROUP3,SOUTH|ORDERACTIVE|CATERING 

                          ] ;

                           

                          //North/south is board ....Orderactive is status ....and Catering  is type

                           

                          please help