4 Replies Latest reply: Aug 15, 2018 4:24 PM by Vu Nguyen RSS

    Section Access

    Jasmeen Kaur

      Hi All,

       

      I am trying to apply section access to two fields (combined as Composite key) but getting error and data loads takes time in hours.

       

       

      Any pointers how to achieve it ?

       

      Two fields on which section access to be applied - Products and Categories

      I want section access to work in way that when i select Product only listed categories in section access should display for particular user

        • Re: Section Access
          Max Pain

          It is not quite clear. Can share your code?

            • Re: Section Access
              Jasmeen Kaur

              I am trying to code something like this:

               

              Section Access;

              Load *  inline

              [

              ACCESS  ,USERID  ,PRODUCTID,CATEGORIES, OMIT

               

              ];

               

              I have to limit Categories as per following:

               

              User a can see only PRODUCT A and only one of the category below

              User b can see all categories under product a

                • Re: Section Access
                  Vu Nguyen

                  You need to explicitly populate all combinations of reduction field values that you want each end-user to see. Let say you have 3 Categories A1,A2,A3 under PRODUCT A. Your Section Access table (for Qlik Sense) should be:

                   

                  Section Access;

                  Load *  inline

                  [

                  ACCESS  ,USERID  ,PRODUCTID,CATEGORIES, OMIT

                  ADMIN, INTERNAL\SA_SCHEDULER,,,

                  USER, UserA, PRODUCT A, A1,

                  USER, UserB, PRODUCT A, A1,

                  USER, UserB, PRODUCT A, A2,

                  USER, UserB, PRODUCT A, A3,

                  ];

                   

                  Section Access table is no special than other tables in your data model except for the fact that it is hidden from users. If your reload takes long time, Section Access isn't likely to be the cause.

                   

                  If you still get error, some screencaps of the error messages should be helpful.

              • Re: Section Access
                David Forest

                What error?

                What does the detail for your section access records look like?

                How much data?

                What's the load time without Section Access?