Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
mwallman
Creator III
Creator III

How to assign a unique number to each Year Month value?

Hi,

I have a YearMonth field where the values are like:

2015-Jan

2015-Feb

2015-Mar

etc

How can create a unique number that gets assigned to each value above? E.g. 2015-Jan would get 1, 2015-Feb would get 2... etc

1 Reply
sunny_talwar

Try AutoNumber(YearMonth)

but make sure that your YearMonth field is sorted in ascending order before you use AutoNumber