0 Replies Latest reply: Feb 17, 2016 5:27 AM by naveen kumar RSS

    how to show break ups

    naveen kumar

      Hello all,

      I need your help in achieving this requirement ,they want to show the current and previous audit score  location wise ,

      which I am able to do that ,so the extension of this requirement is when end user click on current score or previous score then he should able to see break up in different quality wise ...what I mean is

       

       


            OVERALL_SCR     =      QUALITY_GOV, SAMPLING,LAB_ANALYSIS, FAIL_MGMT, SUPP_MGMT, RM_SPEC,MAT_MGMT,   LAB_INSTR_MGMT

      All these fields are predefined fields ,In SCRIPT level what i try to do is


      AuditScore:

       

       

      LOAD MANDT,

           WERKS as WERK,

           date(ADATE,'MM/DD/YYYY') AS ADATE,

           QUARTER,

           OVERALL_SCR,

          QUALITY_GOV,

          SAMPLING,

           LAB_ANALYSIS,

           FAIL_MGMT,

           SUPP_MGMT,

         RM_SPEC,

           MAT_MGMT,

           LAB_INSTR_MGMT

          

      FROM

      [C:\qlikview\QVDS\AuditScore.qvd]

      (qvd);

       

      table:

      CrossTable(quality,values,1)

      LOAD QUARTER, //(i just blindly took this quater field so that i can have association with top table)

      QUALITY_GOV,

          SAMPLING,

           LAB_ANALYSIS,   //i am trying to group all these 8 fields in to one filed using cross table which i am success in doing that

           FAIL_MGMT,

           SUPP_MGMT,

         RM_SPEC,

           MAT_MGMT,

           LAB_INSTR_MGMT

           Resident AuditScore;

      finally i want to show these two fields as shown in the last slide

      RESULT :     

         qualityfield          values        


       

      Expression :

      current score

      FirstSortedValue(OVERALL_SCR,-ADATE)

      pervious score

      FirstSortedValue(OVERALL_SCR,-ADATE,2)

       

      please find the attachment and the raw data aswell