topic Re: What is the use of AutoNumber() ?? in QlikView

What is the use of AutoNumber() ??

nikhilgarg — Tue, 13 Jan 2015 12:56:34 GMT

HEy,

What is the use of AutoNumber() ?? Please help by an example.

Thanks

Re: What is the use of AutoNumber() ??

Gysbert_Wassenaar — Tue, 13 Jan 2015 13:00:59 GMT

See this blog post: Counters in the Load

Or this one: QlikView Addict: QlikView Functions: autonumber()

Re: What is the use of AutoNumber() ??

Clever_Anjos — Tue, 13 Jan 2015 13:01:28 GMT

Usually for creating ID´s for composite fields

LOAD

Autonumber(Customer & Company) as CustID

Re: What is the use of AutoNumber() ??

Tue, 13 Jan 2015 14:26:24 GMT

Hi,

The AutoNumber() function is useful if you want to put a number on a specific field value, or on an attribute that is a combination of field values. The attributes will be numbered and their numbers re-used appropriately.

AutoNumber( Product & '|' & Date ) as ID

Re: What is the use of AutoNumber() ??

Wed, 14 Jan 2015 14:01:01 GMT

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

Autonumber is basically used to generate index which will help in joining the table and improve the processing time.

Re: What is the use of AutoNumber() ??

nikhilgarg — Thu, 15 Jan 2015 07:19:02 GMT

HEy,

I didn't get you.

Can you explain it again ?

Thanks

Re: What is the use of AutoNumber() ??

Thu, 15 Jan 2015 07:25:41 GMT

If we have Employee Name as the Key to join two tables then it will join on the bases of Char fields ie Nikhil Garg.

But if we do autonumber(Employee Name) then it will give unique number to each record in Employee Name field. So instead of Nikhil Garg it can be numbers i.e. 1. So the performance may increase there is huge records in Employee Name fields, as we are joining on the bases of index(integer) instead of Char.

Re: What is the use of AutoNumber() ??

nikhilgarg — Thu, 15 Jan 2015 07:27:50 GMT

HEy,

Ok i got it . I tried a n example with auto number. It just acts like a serial Number in front of fields.

Isn't it ??

thanks

Re: What is the use of AutoNumber() ??

Thu, 15 Jan 2015 07:29:52 GMT

Yes you are right. its giving index(serial Number) to each unique records in that field.

Re: What is the use of AutoNumber() ??

Anonymous — Thu, 15 Jan 2015 07:31:02 GMT

yes Nikhil you are correct .

it works like surrogate Key in database.

it will generate incremental numbers llike , 1,2,3,4.....n

Re: What is the use of AutoNumber() ??

nikhilgarg — Thu, 15 Jan 2015 07:36:52 GMT

But in some examples i have seen using Autonumber(1) ;

What is the sue of this??

Re: What is the use of AutoNumber() ??

nikhilgarg — Thu, 15 Jan 2015 07:36:59 GMT

But in some examples i have seen using Autonumber(1) ;

What is the sue of this??

Re: What is the use of AutoNumber() ??

nikhilgarg — Thu, 15 Jan 2015 09:31:12 GMT

Hey,

WHat is the difference between Autonumber (1) and Autogenerate 1 ??

Re: What is the use of AutoNumber() ??

nikhilgarg — Thu, 15 Jan 2015 09:31:16 GMT

Hey,

WHat is the difference between Autonumber (1) and Autogenerate 1 ??

Re: What is the use of AutoNumber() ??

arixooo123 — Tue, 30 May 2017 23:49:21 GMT

Hi Clever

If we use Autonumber on two different tables but on the same fields, let's say Sales Table and Cost Table, will it generate the numbers in a way that customers and companies on both table match with the same key number?

I mean if the function generate some numbers independently, it won't work the way that we want to.

Re: What is the use of AutoNumber() ??

Clever_Anjos — Thu, 01 Jun 2017 12:36:01 GMT

Autonumber() will return same values for same input

Example

Autonumber('foo') returns 5 for example, anytime 'foo' is read no matter what field, 5 will be returned

If you need different values for different fields, use an identificator

Autonumber('foo','Sales Table') and Autonumber('foo','Cost Table')

can (not always) return different values

Re: What is the use of AutoNumber() ??

arixooo123 — Thu, 01 Jun 2017 23:22:34 GMT

Thanks Clever,

You said and I quote:

Autonumber('foo','Sales Table') and Autonumber('foo','Cost Table')

can (not always) return different values

If they could return different outputs for the same input, then the rows will not be matched and our calculations won't return the correct result. Is that right?

You see, we have a couple of complex keys on some huge tables, I was wondering if using autonumber to replace those keys could be beneficial in terms of memory usage. what's your suggestion?

Re: What is the use of AutoNumber() ??

Clever_Anjos — Fri, 02 Jun 2017 11:07:53 GMT

>>If they could return different outputs for the same input, then the rows will not be matched and our calculations won't return the correct result. Is that right? Depends what you name "correct", that function will return same values if you need, and maybe different ones if you don´t need.

I suggest you using autonumber and their similars autonumberhash()

Re: What is the use of AutoNumber() ??

Ron1 — Tue, 28 Jan 2020 15:46:34 GMT

I am using Autonumber() on my date field to due to some business requirement to generate serial numbers.

However it is not generating serial numbers. Can you please help me to fix this

See below:

Date	Number
05.12.2019	31
12.12.2019	32
19.12.2019	33
26.12.2019	35
02.01.2020	34