Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

autonumber (on all fields)

Does anyone know if there is a shortcut to determine an autonumber on all fields in a record without having to add all fields in the autonumber statement?

autonumber(Field1&Field2&....) as Checksum

autonumber(*) as Checksum (which is not working)

1 Reply
Not applicable
Author

hi,

The purpose of autonumber function is to generate hashcode number from an input string.

that's why there is no shotcurt for all fields , you must add '&' between fields name .

NB :

We use this function in qlikview's script to avoid loops between two table ,by creating one field for multiple common fields between two table . So , if your purpose is to avoid loops there is no need to create autonumber for all fields ( in this case two table contain exactly the same name of attribute , so please use qualify and unqualify ) .