Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Pomna
Creator III
Creator III

AutoNumber (Recno())

I would like to use the auto number function Recno(). what am getting is 1,2,3 but what I need to see is 001, 002, 003. Any suggestions please? Thank you

 

1 Solution

Accepted Solutions
jwjackso
Specialist III
Specialist III

Try Num(AutoNumber(Recno()),'000')

View solution in original post

2 Replies
jwjackso
Specialist III
Specialist III

Try Num(AutoNumber(Recno()),'000')

Pomna
Creator III
Creator III
Author

Thank you. It worked