Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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.

1 Solution

Accepted Solutions
SunilChauhan
Champion II
Champion II

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

Sunil Chauhan

View solution in original post

2 Replies
SunilChauhan
Champion II
Champion II

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

Sunil Chauhan
Not applicable
Author

thank u very much Sunil...