Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
MRitter
Employee
Employee

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.  

Thanks

Labels (1)
0 Replies