Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

New to Qlik Analytics

If you’re new to Qlik Cloud or Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!

Who Me Too'd this topic

fishing_weights
Contributor III
Contributor III
‎2024-02-15 02:11 AM

creating unique ID by numbering occurance of a value in script

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
1 user say ditto
552 Views
Who Me Too'd this topic