Qlik Community

Qlik Sense Advanced Authoring

Discussion board where members can learn more about Qlik Sense Advanced Authoring.

BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
Showing results for 
Search instead for 
Did you mean: 

Need total items open at end of each month (including historical)

I am having difficulty thinking this one through

I have item records that are submitted into the system and then sit there until they are assigned.  I have a flag that indicates if it has been assigned and I capture the date that it was assigned.  I also have the submitted date.

What I need is a line chart showing the total number of items that were not assigned at the end of each month.

If submitted and assigned in the same month it does not get counted.

If submitted in Jan. and not assigned until Feb. it should count as 1 in Jan and 0 in Feb.

If submitted in Jan and not assigned until March it should count as 1 in Jan and 1 in Feb and 0 in March.

And so on.  


0 Replies