Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

What is the use of Auto Number?Autonumber128? What is the disadvantages of using Autonumber128?

Hi All,

What is the use of Auto Number?Autonumber128? What is the disadvantages of using Autonumber128?

Thanks,

Attitude

1 Reply
Not applicable

What is the use of Auto Number?Autonumber128? What is the disadvantages of using Autonumber128?

I don't know full diferences, but one very important is:

Autonumber has a second parameter, called AutoID to create separate list of value for each concept.

For example I have 10Millions of Document ID, then 10 Million of Customer ID also in the autonumber list, and then 200 Product ID.

It's a best practice to separate products on a diferent list of values, because find/insert value product 199 in a list of 198 products is better than finding in a list of 20.000.198 records.