Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
nicolai_moller
Contributor
Contributor

Assign a number to each value in a field

Hi

I'm trying to create a field that assigns a dynamic number to each value in a field, based on which value has the youngest date.

The value with the youngest date should be assigned the number 1, the second youngest number 2 and so on.

Each of these numbers should be unique so if some values share the same date, they should be assigned different numbers.

I have attached some random data with some dates.

Thanks.

1 Solution

Accepted Solutions
tresesco
MVP
MVP

May be like this ? PFA.

View solution in original post

1 Reply
tresesco
MVP
MVP

May be like this ? PFA.