topic Re: Staff Availability in QlikView https://community.qlik.com/t5/QlikView/Staff-Availability/m-p/18345#M3034 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/qlik-users/23109">jagan</A>‌</P></BODY></HTML> Fri, 11 May 2018 09:17:01 GMT vardhancse 2018-05-11T09:17:01Z Staff Availability https://community.qlik.com/t5/QlikView/Staff-Availability/m-p/18343#M3032 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>I have one requirement based on 2 data sets:</P><P>1. Staff roster</P><P>2. Leave data</P><P></P><P></P><P>Requirement:</P><P></P><P>Line Chart</P><P></P><P>x axis: time (hh:mm)</P><P>Y Axis:&nbsp; Calculate # of staff available ( Total FTE on Roster - Total FTE on LEave)</P><P></P><P>On selected date like for e.g 11/05/2018</P><P></P><P>I need to have staff availability based on roster and leave</P><P></P><P>PFA excel "Roster", "Leave" &amp; "Chart"</P><P></P><P><SPAN style="color: #262626;"> </SPAN></P></BODY></HTML> Fri, 11 May 2018 06:26:18 GMT https://community.qlik.com/t5/QlikView/Staff-Availability/m-p/18343#M3032 vardhancse 2018-05-11T06:26:18Z Re: Staff Availability https://community.qlik.com/t5/QlikView/Staff-Availability/m-p/18344#M3033 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/qlik-users/199510">duncanblaine</A>‌</P></BODY></HTML> Fri, 11 May 2018 08:25:45 GMT https://community.qlik.com/t5/QlikView/Staff-Availability/m-p/18344#M3033 vardhancse 2018-05-11T08:25:45Z Re: Staff Availability https://community.qlik.com/t5/QlikView/Staff-Availability/m-p/18345#M3034 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/qlik-users/23109">jagan</A>‌</P></BODY></HTML> Fri, 11 May 2018 09:17:01 GMT https://community.qlik.com/t5/QlikView/Staff-Availability/m-p/18345#M3034 vardhancse 2018-05-11T09:17:01Z