autonumber (on all fields)

Mon, 28 Jun 2010 09:49:11 GMT

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)

Re. :autonumber (on all fields)

Mon, 28 Jun 2010 13:20:50 GMT

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 ) .

topic Re. :autonumber (on all fields) in QlikView

autonumber (on all fields)

Re. :autonumber (on all fields)