Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Populate data in line chart between two dates

Hello All,

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: Populate data between Start and End dates in line line chart 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?



Community Browser