2 Replies Latest reply: Dec 24, 2013 12:16 AM by jagan mohan rao appala RSS

    Section Access Problem


      Hello,

      I have a ierarchy of data,like:

      Naion->region-> Territory.

      Now i want to give section access like if person from territory1 will log in then he should be able to see his own territory data as well as the region and nation level overview data.

      How such access should be given??

       

      thanks in advance..!!!

        • Re: Section Access Problem
          jagan mohan rao appala

          HI,

           

          Try this

           

          How to Distribute Dashboard and Implement Section Access

           

          From Qlikview Help file:

          Example:

          section access;

          load * inline [

          ACCESS, USERID,REDUCTION, OMIT

          ADMIN, ADMIN,*,

          USER, A,1

          USER, B, 2,NUM

          USER, C, 3, ALPHA

          ];

          section application;

          T1:

          load *,

          NUM AS REDUCTION;

          load

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

          RechNo() AS NUM

          AUTOGENERATE 3;

           

          The field REDUCTION (upper case) now exists in both section access and section application (all field values are also upper case). The two fields would normally be totally different and separated, but if the Initial Data Reduction Based on Section Access option has been selected, they will link and reduce the number of records displayed to the user.

          The field OMIT in section access defines the fields that should be hidden from the user.

          The result will be as follows:

          User A can see all fields, but only those records connected to REDUCTION=1.

          User B can see all fields except NUM, and only those records connected to REDUCTION=2.

          User C can see all fields except ALPHA, and only those records connected to REDUCTION=3.

           

          Regards,

          Jagan.

          • Re: Section Access Problem
            Sampath Kumar

            Priya,

            Implement section access in territory level.

            The user who is having access to the territorry1 will see the region and national level data which belongs to territory1.

             

             

             

            Thanks,

            sampath