topic AutoNumber() function - how does it work? in QlikView https://community.qlik.com/t5/QlikView/AutoNumber-function-how-does-it-work/m-p/402675#M696112 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>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.</P><P>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.</P><P></P><P>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?</P><P></P><P>Thanks a lot!</P><P>Best regards,</P><P></P><P>DataNibbler</P></BODY></HTML> Fri, 26 Apr 2013 08:35:58 GMT datanibbler 2013-04-26T08:35:58Z AutoNumber() function - how does it work? https://community.qlik.com/t5/QlikView/AutoNumber-function-how-does-it-work/m-p/402675#M696112 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>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.</P><P>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.</P><P></P><P>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?</P><P></P><P>Thanks a lot!</P><P>Best regards,</P><P></P><P>DataNibbler</P></BODY></HTML> Fri, 26 Apr 2013 08:35:58 GMT https://community.qlik.com/t5/QlikView/AutoNumber-function-how-does-it-work/m-p/402675#M696112 datanibbler 2013-04-26T08:35:58Z