4 Replies Latest reply: Mar 22, 2017 4:56 PM by Vladimir Komarov RSS

    Section Access

    Andre Costa

      Hello community!

       

      I have a doubt regarding Section Access. I have a QV app with data regarding sales and warehouse information.

       

      I want to develop a section access for each salesman to view only their own sales but the warehouse information (which as no relation with salesman) must be visible for all users.

       

      The first part (setting up section access for each salesman) is correct but, since there is no relation to salesman, the warehouse information is gone.

       

       

       

      Any ideas?

       

      Thanks in advance,

      Andre

        • Re: Section Access
          Vladimir Komarov

          Andre,

           

          You need to create REDUCTION field for Warehouse data as well and assign the '*' value for EVERY salesmen in your Section Access table...

           

          Qlik supports multiple Reduction levels, so it should work well for you.

           

           

          Regards,

          Vlad

           

          P.S. When applicable, please mark this answer Correct or Helpful.

            • Re: Section Access
              Andre Costa

              Thanks for your answer Vladimir.

               

              The reduction field is the Salesman Code, if I join/ concatenate it to the warehouse data it will change the warehouse values, am I right?

               

              For example, for 10 salesman it will multiply my stock value by 10.

               

              Sooooo confused

                • Re: Section Access
                  Andre Costa

                  Vladimir suggestion pointed me in the right track.

                   

                  I've created a dummy salesman in the warehouse data, this way users can see their sales aswell as the warehouse data.

                   

                  In section access, each salesman must be granted access to his own salesman code and to the dummy salesman.

                    • Re: Section Access
                      Vladimir Komarov

                      Andre,

                       

                      I've started writing a reply and saw that you've found a solution, but here is my suggestion also (since I am already writing it):

                       

                      You are correct, you do not need to add a [Salesman Code] to your warehouse data..

                      Here is the example:

                       

                      Section Access;

                       

                      Security:

                      LOAD

                        'USER' as ACCESS,

                        upper("USERID") as USERID,

                        SALESMAN_CODE as REDUCTION_C,

                        WAREHOUSE_GROUP as REDUCTION_F,

                        '' as OMIT

                      FROM [XXXXXXX]

                      ;

                       

                       

                      And your Section Access table should look like:

                      Screen Shot 2017-03-22 at 3.47.58 PM.png

                       

                      Your warehouse table should look like this:

                      WH:

                      load

                      'WH' as WAREHOUSE_GROUP,

                      ....

                      FROM [WWWWWW]

                      ;

                       

                      And your SalesPeople data load should be just like this:

                      SP:

                      load

                      SALESMAN_CODE,

                      .....

                      FROM [SSSSSS]

                      ;

                       

                      In the example above each user has an access to his/her own SALESMAN data and also to ALL records in WH table.

                       

                      Regards,

                      Vlad