1 Reply Latest reply: Mar 27, 2017 1:35 PM by Shahbaz Khan Mohammed RSS

    data reduction in section access using qliksense

    shruthi PANNALA
    shruthi PANNALA Mar 27, 2017 12:16 PM

      Hi Friends, I am implementing data reduction in section access using qliksense but it doesnt seems to working ,can some body guide me on implemeting data reuction in qliksense, below is screen shot of my code

       

      I have user abc, and member name is one field name one of the tables in my data .

      I would like to show the data related to particular member name called "Teacher" to that user abc, when i implement below code, it doesn't seems to be working, it is showing all the data to the user

       

      DataReductionin SectionAccessError.jpg

        • Re: data reduction in section access using qliksense
          Shahbaz Khan Mohammed
          Shahbaz Khan Mohammed Mar 27, 2017 1:35 PM (in response to shruthi PANNALA)

          Try the below script

          Star is *;

           

           

          section access;

          LOAD * INLINE [

              ACCESS, USERID, JOBFUNCTION, ORG

              USER, CORP\USERNAME1, AAA, CA

              USER, CORP\USERNAME1, BBB, AB

              USER, CORP\USERNAME1, CCC, BC

              USER, CORP\USERNAME1, DDD, CD

              USER, CORP\USERNAME, *, *

              USER, INTERNAL\SA_SCHEDULER, ,

              USER, CORP\USERNAME2, EEE, AZ

              USER, CORP\USERNAME2, FFF, QA

              USER, CORP\USERNAME2, JJJ, RT

          ];

          section application;

           

           

           

          LOAD * INLINE [

              COUNTRY, SALES, MARGIN, PROFIT, ORG, JOBFUNCTION

              USA, 100000, 10000, 10, CA, AAA

              USA, 200000, 10000, 20, AB, BBB

              USA, 300000, 10000, 30, BC, CCC

              USA, 400000, 10000, 40, CD, DDD

              USA, 500000, 10000, 50, QW, EEE

              USA, 600000, 10000, 60, BB, FFF

              USA, 700000, 10000, 70, ZA, GGG

              USA, 800000, 10000, 80, AZ, HHH

              USA, 900000, 90000, 90, QA, III

              USA, 100000, 10000, 10, RT, JJJ

              EU, 110000, 11000, 110, ER, KKK

              EU, 120000, 12000, 120, WE, LLL

          ];

           

          Note: replace Username with your users