Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Employee visit chart

Hi all,

I have a real trouble with this chart, hope somebody can help me

I need to show the presence of employees at work as a two-coloured bar where one colour is the worktime and the other is permanent absence time. In the organization we have 4 types of work statuses(Present, Absent , Delay and Permanent absence) and a number of additional statuses for the status "Permanent absence" - e.g. Dinner, Business trip...

The next status starts at the same time when the previous ends, so I have 2 fields for each status - Starttime and Endtime

The best solution I've found is to make a Gant chart. But it works only for different phases and if I have 2 statuses of presence each day(before and after dinner) - I can't see the dinner time. For better diversification I've concatenated the status with the previous status

Another problem is that I have a status "Absent" which starts at one day and stops onle the next day, so this chart works absolutely incorrect

Here's the example

Hope, you've catched the idea and thanks in advance for any help...


Community Browser