Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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.

datanibbler
Not applicable

AutoNumber() function - how does it work?

Hi,

I've read several times about the AutoNumber() function in QlikView. Just now I came across it again in a post collecting some general hints on performance tuning - to use numeric keyfields between tables instead of STRINGs. I have six tables in my datamodel currently. All of them are connected via some ID-number, which does not say it might not be in STRING format, I don't know.

Is there a way to find that out in QlikView? Finding out what type the field is in the underlying database will be a bit more troublesome.

Second, more important question: What happens if I apply the AutoNumber() function to a keyfield where the table_viewer says "Primary key" or "key", meaning the field is not unique?

Thanks a lot!

Best regards,

DataNibbler