Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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!