2 Replies Latest reply: Jun 22, 2011 7:50 AM by senthila RSS

    How to do this/

      I dont know how to start this please guide me to make a Employee leave status report for the year with different colors used to indicate whether the leave is approved, pending or rejected. attached document contains data.

        • How to do this/
          Sunil Chauhan

          hello senthila,

           

           

          Load employeeInfo and leave app into qlikview file. link both by Employee Id

          take a pivot table

          In dimension

          Name and ApplyDate

          in expresssion:

           

          if(ApplicationStatus='Rejected','qmem://<bundled>/BuiltIn/led_r.png',

          if(ApplicationStatus='Approved','qmem://<bundled>/BuiltIn/led_g.png',

          if(ApplicationStatus='Approved','qmem://<bundled>/BuiltIn/led_y.png')))

           

          in representation seleect image.

           

          in second chart

          use grid chart

          use day Month whatever u want in a drill group and

          and calculation .

           

          hope this will help

           

           

          Regards

          Sunil