Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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

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

View solution in original post

1 Reply
Nicole-Smith

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