Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

schlagmp
New Contributor

Count Asset Creation by Type for each month

We are tracking when an asset (equipment) is added to our EAM system in Qlik.  I want to show how many of each type was created in each month.  Right now it totals it every month which includes all previous months. 

Asst Type by Month.jpg

We didn't create 110 PMP type assets in October of 2017, we created 10.  So I would need some sort of expression that counts the created assets each month and then show that by type.  Any help to get me going in the right direction would be appreciated.  Thanks.