How to do this/

[#1]

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.

[SunilChauhan · Accepted solution]

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

[#3]

thank u very much Sunil...