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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
lg92
Contributor II
Contributor II

Count ID only on max(data)

Hi,

I need to count IDs only if max(data).

For example:

IDs    Data

1      29/11/2020

2      29/11/2020

3     29/11/2020

4     30/11/2020

5     30/11/2020

The result of counter is 2 because 30/11 > 29/11 and there are two ID's (4,5)

Thank you in advance.

Labels (2)
1 Solution

Accepted Solutions
Nicole-Smith
MVP
MVP

This should work:
count({<Data = {'$(=maxstring(Data))'}>} IDs)

View solution in original post

1 Reply
Nicole-Smith
MVP
MVP

This should work:
count({<Data = {'$(=maxstring(Data))'}>} IDs)