5 Replies Latest reply: Jun 18, 2018 1:01 AM by kishor J RSS

    Section access in Qlik sense

    kishor J

      Hi All,

       

      We are getting uers from AD.Could you please how to apply section access for AD users.

      How to we apply the roles please assist me.

       

      Thanks

        • Re: Section access in Qlik sense
          kishor J

          Hi All,

           

          We have users assigned to respective group.

          instead of users level we need to implement section access on gorup level.

          Could you please suggest how do we implement section access on group level.

          it would be better if you could share 1 example with me.

           

          We have format as per below.

             

          USERIDTYPEVALUE
          CABTEST\svc_cdpadminGROUPadmin
          AP\tibhedeeGROUPQlik Sense User

             

           

          USERIDNAME
          AP\tibhedeeTibhe Deepak
          CABTEST\svc_cdpadminService Account

           

          Thanks.

            • Re: Section access in Qlik sense
              praveen kumar

              Hi  Kishor,

               

              This might Help you ..

               

              Example: Data reduction based on user groups

              section access;

              LOAD * inline [

              ACCESS, USERID, GROUP, REDUCTION, OMIT

              USER, *, ADMIN, *,

              USER, *, A, 1,

              USER, *, B, 2, NUM

              USER, *, C, 3, ALPHA

              USER, *, GROUP1, 3,

              ADMIN, INTERNAL\SA_SCHEDULER, *, *,

              ];

              section application;

              T1:

              LOAD *,

              NUM AS REDUCTION;

              LOAD

              Chr( RecNo()+ord('A')-1) AS ALPHA,

              RecNo() AS NUM

              AUTOGENERATE 3;

              The result will be:

              • Users belonging to the ADMIN group are allowed to see all data and all fields.
              • Users belonging to the A group are allowed to see data associated to REDUCTION=1 across all fields.
              • Users belonging to the B group are allowed to see data associated to REDUCTION=2, but not in the NUM field
              • Users belonging to the C group are allowed to see data associated to REDUCTION=3, but not in the ALPHA field
              • Users belonging to the GROUP1 group are allowed to see data associated to REDUCTION=3 across all fields
              • The user INTERNAL\SA_SCHEDULER does not to belong to any groups but is allowed to see all data in all fields.

                The wildcard, character *, in this row refers only to all values within the section access table. If there are values in the section application that are not available in the REDUCTION field in section access, they will be reduced.

               

               

              Thanks

              PM

                • Re: Section access in Qlik sense
                  kishor J

                  Hi Praveen,

                   

                  Thanks for the response.

                   

                  We have scenario as per below,

                   

                  We have 3 kind of Customers,

                  Secret Customers

                  Mega Customers

                  General Customers.

                   

                  Secret Customers should have an access for Secret Customers group as well as General Customers

                  Mega Customers should have an access for Mega Customers group as well as General Customers.

                  And for only General Customers  access Secret and Mega Customer group is not visible.

                   

                  Could you please suggest how to apply section access(Document level,Object level,Field level,Column level) in qlik sense based on above scenario's

                   

                  Thanks

                  • Re: Section access in Qlik sense
                    kishor J

                    Hi,

                     

                    This is not working

                     

                    Thanks