topic Re: when we use Autonumber function in qlikview? in QlikView

when we use Autonumber function in qlikview?

Tue, 22 Jul 2014 07:59:00 GMT

Hi,

Anyone please tell me

Regards,

Devi.

Re: when we use Autonumber function in qlikview?

its_anandrjs — Tue, 22 Jul 2014 08:03:25 GMT

When there is need for Unique numbers in the table or data model See the example from the 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' )

Re: when we use Autonumber function in qlikview?

Tue, 22 Jul 2014 08:08:46 GMT

Hi,

Autonumber is used in many case

one of the most important use is ,

Like u have 2 column as string or number and by concatenating two column you are making primarykey

string as a primary key will degrade the performance of your application, so in that case we use autonumber to generate primary key.

Hope this helps

Re: when we use Autonumber function in qlikview?

Siva_Sankar — Tue, 22 Jul 2014 08:15:40 GMT

Devi,

While creating a datamodel, 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.

Re: when we use Autonumber function in qlikview?

ali_hijazi — Tue, 22 Jul 2014 08:17:51 GMT

autonumber simply transforms a string value as number

but be aware of this fact

suppose autonumber('abc') is 500 and you saved this info as QVD

then on an another reload autonumber('abc') may not be 500 while the value that you saved was 500

Re: when we use Autonumber function in qlikview?

Fri, 14 Nov 2014 10:20:33 GMT

I suggest you to concatenate a separator between the fields such as "|"

Imagine the scenario:

Record1 = FieldA=100 and FieldB=10

Record2 = FieldA=10 and FieldB=010

Using only Autonumber:

Autonumber(Record1) = Autonumber(10010) = x

Autonumber(Record2) = Autonumber(10010) = x

Using Autonumber with separato:

Autonumber(Record1) = Autonumber(100|10) = z

Autonumber(Record2) = Autonumber(10|010) = y

It could be difficult to happen but... It's better to prevent

Re: when we use Autonumber function in qlikview?

Thu, 22 Jan 2015 16:40:54 GMT

Just beware that the Autonumber() function creates an internal table during the script load, and these tables are dropped after the load.

For this reason, while performing partial reload, the Autonumber() function will not consider the already loaded values when building the internal table, and will ultimately generate duplicates in your model.