Filtering Out Information Based on the Value in a Field

[MTS95]

Hi there,

I am trying to create a table that excludes some information based on the value in a field from some Excel documents I uploaded. To elaborate: I uploaded 4 different Excel files that show how up-to-date some assets on a website are, each one from a different date (one is from July 15th of 2021, another from October 2021, another from December 2021, and the last from January of 2022).

I gave each dataset a column labelled "Date of Collection" to differentiate each asset from the assets with the same names in the other files (7/15/2021 for the dataset from July 2021, 10/26/2021 for October's, etc.), and for the first sheet in my app, I was hoping to have a table with different bins to show how far out of date each asset was at the time the dataset was downloaded.

I've attached a photo of my Qlik sheet so far--the correct number of assets is 4,591 like in the KPI visualization, but notice that the total number of assets in the right column of the "Number of Datasets Out of Date, by Days" table is pulling all 14,808 assets from all 4 datasets. Here is also the code I initially tried putting into the Expression field in the properties tab:

Count({<[Date of Collection]={'7/15/2021'}>}[Date of Collection])

Any insight you may have is appreciated; let me know if I need to clarify anything. Thank you for your help!