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

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
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.