topic Re: Autonumber() Fn use? in QlikView

Autonumber() Fn use?

sonysree88 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

Can you please let me know the use of Auto number and difference between Row no(), Auto number()

Regards

Sony

Re: Autonumber() Fn use?

avinashelite — Mon, 22 Aug 2016 12:59:12 GMT

check this

Autonumber(), Recno(), rowno()

Re: Autonumber() Fn use?

maxgro — Mon, 22 Aug 2016 13:00:50 GMT

.... and difference between Row no(), Auto number()

Counters in the Load

Sometimes (when you have a large number of unique long string values) autonumber is used to reduce the RAM used by QlikView

Re: Autonumber() Fn use?

sonysree88 — Mon, 22 Aug 2016 13:04:26 GMT

Hi Avinash,

Thanks for your fast reply here only row no(),rec no() functions will be there.

Can you post the use of auto number()

Re: Autonumber() Fn use?

avinashelite — Tue, 23 Aug 2016 06:52:23 GMT

check this post

What is the use of AutoNumber() ?? | Qlik Community

Re: Autonumber() Fn use?

Anonymous — Tue, 23 Aug 2016 06:57:05 GMT

Hi,

Autonumber function returns a different number for each value of the field, regardless of the table that you are. That is, for the value A in the X table and the table, the function will return 1.

Regards!