Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
newbie_sm
Contributor III
Contributor III

How to count new records?

I have list of users for different months: e.g.

Month - 2022 Dec and records = B, C, D, H

Month - 2023 Jan and records = A, C, D, E, F 

Month - 2023 Feb and records = A, B, D, G, H

What is the formula to count new records in 2023 FEB only?  Answer should be  = 1 for "G" only.

Labels (2)
1 Solution

Accepted Solutions
Gabbar
Specialist
Specialist

I suppose you also have respective dates correlating to you month-year column, Lets Name the Column Date.
Try this:
Count({<records=e({<Date={"<$(=MonthStart(Max(Date)))"}>})>}records)

View solution in original post

2 Replies
Gabbar
Specialist
Specialist

I suppose you also have respective dates correlating to you month-year column, Lets Name the Column Date.
Try this:
Count({<records=e({<Date={"<$(=MonthStart(Max(Date)))"}>})>}records)

newbie_sm
Contributor III
Contributor III
Author

Thank you so much - the formula works!