topic Employee visit chart in QlikView https://community.qlik.com/t5/QlikView/Employee-visit-chart/m-p/549158#M480916 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>I have a real trouble with this chart, hope somebody can help me</P><P></P><P>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...</P><P></P><P>The next status starts at the same time when the previous ends, so I have 2 fields for each status - Starttime and Endtime</P><P></P><P>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</P><P></P><P>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</P><P>Here's the example</P><P></P><P>Hope, you've catched the idea and thanks in advance for any help...</P><P>Kristina</P></BODY></HTML> Wed, 30 Oct 2013 12:20:33 GMT 2013-10-30T12:20:33Z Employee visit chart https://community.qlik.com/t5/QlikView/Employee-visit-chart/m-p/549158#M480916 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>I have a real trouble with this chart, hope somebody can help me</P><P></P><P>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...</P><P></P><P>The next status starts at the same time when the previous ends, so I have 2 fields for each status - Starttime and Endtime</P><P></P><P>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</P><P></P><P>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</P><P>Here's the example</P><P></P><P>Hope, you've catched the idea and thanks in advance for any help...</P><P>Kristina</P></BODY></HTML> Wed, 30 Oct 2013 12:20:33 GMT https://community.qlik.com/t5/QlikView/Employee-visit-chart/m-p/549158#M480916 2013-10-30T12:20:33Z