Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor
Contributor

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 (3)
1 Solution

Accepted Solutions

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

View solution in original post

1 Reply

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

View solution in original post