topic Days worked and shifts in QlikView https://community.qlik.com/t5/QlikView/Days-worked-and-shifts/m-p/364960#M135778 <HTML><HEAD></HEAD><BODY><P> Hi all,</P><P></P><P></P><P>I've have an interesting one here.</P><P>I have a .qvw which the user selects a start date to work and enddate to work for that week-using variables.(vStartDate -vEndDate for the week) They are being written to an excel file, using input boxes./calendars.</P><P>Each day worked can have either an am ; pm ; eve shift they can work, for that day. One employee could work am and pm for the day or even all 3, or even just one shift.</P><P>The work week is from Monday to Saturday-so could be 6 days.</P><P></P><P>How could I got about dynamically giving the user an option to select a shift for each day selected. ?</P><P>eg. 26/11/2011 - am and pm</P><P>27/11/2011- pm and eve</P><P>28/11/2011 - am</P><P></P><P></P><P>Potentially there could be lots of shifts for each employee each week.</P><P></P><P></P><P></P><P>Any ideas?</P></BODY></HTML> Thu, 22 Mar 2012 14:42:31 GMT 2012-03-22T14:42:31Z Days worked and shifts https://community.qlik.com/t5/QlikView/Days-worked-and-shifts/m-p/364960#M135778 <HTML><HEAD></HEAD><BODY><P> Hi all,</P><P></P><P></P><P>I've have an interesting one here.</P><P>I have a .qvw which the user selects a start date to work and enddate to work for that week-using variables.(vStartDate -vEndDate for the week) They are being written to an excel file, using input boxes./calendars.</P><P>Each day worked can have either an am ; pm ; eve shift they can work, for that day. One employee could work am and pm for the day or even all 3, or even just one shift.</P><P>The work week is from Monday to Saturday-so could be 6 days.</P><P></P><P>How could I got about dynamically giving the user an option to select a shift for each day selected. ?</P><P>eg. 26/11/2011 - am and pm</P><P>27/11/2011- pm and eve</P><P>28/11/2011 - am</P><P></P><P></P><P>Potentially there could be lots of shifts for each employee each week.</P><P></P><P></P><P></P><P>Any ideas?</P></BODY></HTML> Thu, 22 Mar 2012 14:42:31 GMT https://community.qlik.com/t5/QlikView/Days-worked-and-shifts/m-p/364960#M135778 2012-03-22T14:42:31Z