Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

use of autonumber?

Hi,

can anyone explain me why we go for autonumber?

if u can, give me an example?

Tags (1)
6 Replies
Not applicable

Re: use of autonumber?

Check the reference manual:

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.

Also search for autonumber in the forum, there are a lot of questions about autonumber.

Employee
Employee

Re: use of autonumber?

Often you need to create composite keys between tables, i.e. keys that are concatenations of several other keys. These composite keys are often 50-100 characters long (or more) and take up a fair amount of memory. But they are usually not displayed.

So, if you want to save some memory space, you should use the Autonumber() function on the composite keys. It replaces long strings with a short number while maintaining all information.

HIC

Not applicable

Re: use of autonumber?

Thanks for ur explanation

Not applicable

Re: use of autonumber?

Thanks for ur explanation

Not applicable

Re: use of autonumber?

thanks for ur explaination

sibideepak
Contributor II

Re: use of autonumber?

Is this the only reason to use autonumber ?

But I thought it will link those tables faster and getting data from other tables will be faster .. Am I right or wrong ?

Just want to know, is there any other side for autonumber.

Community Browser