Qlik Community

Ask a Question

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
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

Try AutoNumber(YearMonth)

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