Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
If you’re new to Qlik Cloud or Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I have a table with IDs. it can appear multiple times. Base on the date field it appears I want to engineer a unique ID in script, numbering off the original ID base on the first time it appears and +1 subsequently. Please see example of End result wanted in third column below.
thanks in
ID | DATE | END RESULT WANTED |
ABC | 01JAN24 | ABC 1 |
ABC | 01FEB24 | ABC 2 |
ABC | 01DEC23 | ABC 3 |
EFG | 01JAN24 | EFG 1 |
EFG | 01FEB24 | EFG 2 |
EFG | 01DEC23 | EFG 3 |