Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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
chauhans85
Esteemed Contributor

How to do this/

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

2 Replies
chauhans85
Esteemed Contributor

How to do this/

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

Not applicable

How to do this/

thank u very much Sunil...

Community Browser