Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a dataset that has alphanumeric fields and dates attached to them. How do I get the most recent alphanumeric entry?
Example:
H0034 | 1/1/2024 |
H0035 | 1/1/2024 |
H0036 | 2/26/2024 |
How do I only pull the 2/26/2024?
I should add, the dates will not always be in order. Example
H0001 | 6/6/2023 |
H0002 | 1/1/2023 |
For this table, I would want to return just the 1/1/2023.
The field name for the H00xx field is [item_mod].
I have tried this: =if(left([item_mod],1)='H', num(replace([item_mod],'H','')), 0) to get the values in numerical order and then using MAX, but that gave me incorrect results.
@Evan0211 can you follow this article from Toni?
https://community.qlik.com/t5/Official-Support-Articles/Sorting-Alphanumeric-Data/ta-p/1712855
Unfortunately, I don't have access to load RecNo in the data load.