Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
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?

Thanks,

Zach

0 Replies