topic How to do this/ in QlikView

How to do this/

Wed, 22 Jun 2011 07:40:28 GMT

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/

SunilChauhan — Wed, 22 Jun 2011 10:35:14 GMT

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

How to do this/

Wed, 22 Jun 2011 11:50:38 GMT

thank u very much Sunil...