Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
thank u very much Sunil...