topic Charts & Date Question.... in QlikView https://community.qlik.com/t5/QlikView/Charts-Date-Question/m-p/261334#M581580 <HTML><HEAD></HEAD><BODY><P>I have a Chart that currently shows the number of Service Desk tickets opened during a year/month and the number of service desk tickets closed within a year/month.&nbsp; The Chart is setup to display for a rolling 12 months period of time</P><P>Each "ticket" has 1 Open Date and 1 Closed Date (no multiple history records for a distinct Ticket Number).</P><P></P><P>Example:</P><P>Ticket 1234 /&nbsp; Opened: 08/01/2011&nbsp; /&nbsp; Closed 11/28/2011</P><P>The question I have.... </P><P>Is there a way to "count" the ticket as open for the 08/2011, 09/2011, and 10/2011 periods within the Chart&nbsp; with only 1 "record" loaded into Qlikview ?</P><P></P><P>Thanks for any Assistance you can provide !!</P></BODY></HTML> Mon, 28 Nov 2011 15:52:40 GMT 2011-11-28T15:52:40Z Charts & Date Question.... https://community.qlik.com/t5/QlikView/Charts-Date-Question/m-p/261334#M581580 <HTML><HEAD></HEAD><BODY><P>I have a Chart that currently shows the number of Service Desk tickets opened during a year/month and the number of service desk tickets closed within a year/month.&nbsp; The Chart is setup to display for a rolling 12 months period of time</P><P>Each "ticket" has 1 Open Date and 1 Closed Date (no multiple history records for a distinct Ticket Number).</P><P></P><P>Example:</P><P>Ticket 1234 /&nbsp; Opened: 08/01/2011&nbsp; /&nbsp; Closed 11/28/2011</P><P>The question I have.... </P><P>Is there a way to "count" the ticket as open for the 08/2011, 09/2011, and 10/2011 periods within the Chart&nbsp; with only 1 "record" loaded into Qlikview ?</P><P></P><P>Thanks for any Assistance you can provide !!</P></BODY></HTML> Mon, 28 Nov 2011 15:52:40 GMT https://community.qlik.com/t5/QlikView/Charts-Date-Question/m-p/261334#M581580 2011-11-28T15:52:40Z Charts & Date Question.... https://community.qlik.com/t5/QlikView/Charts-Date-Question/m-p/261335#M581581 <HTML><HEAD></HEAD><BODY><P>Probably you could do it like shown in this thread:</P><P><A class="jive-link-external-small" href="http://community.qlik.com/message/7069#7069">http://community.qlik.com/message/7069</A></P><P></P><P>Hope this helps,</P><P>Stefan</P></BODY></HTML> Mon, 28 Nov 2011 16:08:05 GMT https://community.qlik.com/t5/QlikView/Charts-Date-Question/m-p/261335#M581581 swuehl 2011-11-28T16:08:05Z