
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
can anyone explain the difference between autonumber() and autogenerate()
can anyone explain the difference between auto-number() and auto-generate()
- Tags:
- new_to_qlikview

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
The major difference is that the function autonumber() does exist, and there is no function autogenerate().
Autonumber() function creates a unique integer for each distinct value.
Autogenerate is used to generate a specified number of rows in the script, it is not a function.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Autogenerate is used to generate records for a table with a load statement.
Autonumber is used to generate a number value from a field value (or any expression in a load statement that returns a value). See this discussion: Re: AutoNumber() vs Auto..Hash()
talk is cheap, supply exceeds demand

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
from QlikView help
autonumber(expression[ , AutoID])
Returns a unique integer value for each distinct evaluated value of expression encountered during the script execution. This function can be used e.g. for creating a compact memory representation of a complex key.
In order to create multiple counter instances if the autonumber function is used on different keys within the script, an optional parameter AutoID can be used for naming each counter.
Examples:
autonumber( Region&Year&Month )
autonumber( Region&Year&Month, 'Ctr1' )
autogenerate is used if data should be automatically generated by QlikView.
Load RecNo( ) as A, rand( ) as B autogenerate(10000);
(Note: The parenthesis after autogenerate is allowed but not required.)
