topic Populate data in line chart between two dates in QlikView https://community.qlik.com/t5/QlikView/Populate-data-in-line-chart-between-two-dates/m-p/1363234#M514904 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P></P><P>I would like to set up a line chart that displays the count of a position, p, required for a contract. The contracts have unique identifiers and a start and end date (when a contract ends the resource frees up and is not included in the count). I found a 90 percent solution to my problem here: <A href="https://community.qlik.com/thread/63223">Populate data between Start and End dates in line line chart</A> using the import script provided by Jean-Pierre. I would like to translate this answer from days into months however. I can get everything working correctly except the date starts at 12/31/1899 which is a problem. It needs to start at 1/1/2017 or whatever the earliest start date is. Can anyone help out with this problem?</P><P></P><P>Thanks,</P><P></P><P>Zach</P></BODY></HTML> Mon, 07 Aug 2017 18:47:26 GMT 2017-08-07T18:47:26Z Populate data in line chart between two dates https://community.qlik.com/t5/QlikView/Populate-data-in-line-chart-between-two-dates/m-p/1363234#M514904 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P></P><P>I would like to set up a line chart that displays the count of a position, p, required for a contract. The contracts have unique identifiers and a start and end date (when a contract ends the resource frees up and is not included in the count). I found a 90 percent solution to my problem here: <A href="https://community.qlik.com/thread/63223">Populate data between Start and End dates in line line chart</A> using the import script provided by Jean-Pierre. I would like to translate this answer from days into months however. I can get everything working correctly except the date starts at 12/31/1899 which is a problem. It needs to start at 1/1/2017 or whatever the earliest start date is. Can anyone help out with this problem?</P><P></P><P>Thanks,</P><P></P><P>Zach</P></BODY></HTML> Mon, 07 Aug 2017 18:47:26 GMT https://community.qlik.com/t5/QlikView/Populate-data-in-line-chart-between-two-dates/m-p/1363234#M514904 2017-08-07T18:47:26Z