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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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.