View product changes between historical snapshot data?
I am relatively new to scripting and creating Qlik Sense apps, but have managed to create my first app for my manager which shows a quantity and $ value of product at monthly historical snapshot dates taken in the Enterprise app from existing .qvd files. So at each historical snapshot date, he and the other managers are able to look at how much backlog exists for various employees that have a set 'open' status in the system, and fall within a set range of product groups.
My problem right now is that they would like to be able to look between the most recent Snapshot Date and an earlier one to see exactly how many items have been set to 'closed' (so a status change from one number code to either of 2 that stand for closed), particular the sum of their value (an existing field), and the quantity of each product type (also an existing code depending on the product), for any particular employee (again, another field that exists already).
There are a couple of issues. There is no field for "closed date" for the backlog items to work with, so I'm thinking my code would have to show the products that existed in a set Snapshot Date that no longer appear in the most recent snapshot.
The app also filters to show only the open backlog quantity in the bar charts, so the results for the above to show specifically what was closed would need to disregard filters that the managers set.
So to summarize, I have Snapshot Dates of open backlog at the end of every month, and at each date, the app is able to sum up the backlog value, and count up the distinct backlog ID's for a total quantity that exists, and the entire thing can be view by employee name. What they want to have added is a way to select an earlier Snapshot date to see a list of what existed in that chart that doesn't exist in the most recent one.
Looking at value and count in the bar chart is done with the following measure functions:
