topic Autonumber in qvd in QlikView https://community.qlik.com/t5/QlikView/Autonumber-in-qvd/m-p/888946#M654286 <HTML><HEAD></HEAD><BODY><P>Hello:</P><P></P><P>I have diferent qvw which create the sales-YEAR,qvd, the first for the closed previous years,the second for the current year without the current month and the third for the current month.</P><P></P><P>The first one is only recharged when a change in data model is necessaty.</P><P>The second is recharged the first day of each month</P><P>The third is executed for 2nd until 31th</P><P></P><P>I also have another qvw which load the data from this qvd, In this app some Autonumber() are need in the load sentece for avoiding syntetics keys.</P><P></P><P>My doubt is which is the best way or best practice to include this Autonumber() or other function in the qvd generators ?</P><P></P><P>Thank you very much</P><P>Joaquín</P></BODY></HTML> Mon, 06 Jul 2015 11:39:17 GMT Joaquin_Lazaro 2015-07-06T11:39:17Z Autonumber in qvd https://community.qlik.com/t5/QlikView/Autonumber-in-qvd/m-p/888946#M654286 <HTML><HEAD></HEAD><BODY><P>Hello:</P><P></P><P>I have diferent qvw which create the sales-YEAR,qvd, the first for the closed previous years,the second for the current year without the current month and the third for the current month.</P><P></P><P>The first one is only recharged when a change in data model is necessaty.</P><P>The second is recharged the first day of each month</P><P>The third is executed for 2nd until 31th</P><P></P><P>I also have another qvw which load the data from this qvd, In this app some Autonumber() are need in the load sentece for avoiding syntetics keys.</P><P></P><P>My doubt is which is the best way or best practice to include this Autonumber() or other function in the qvd generators ?</P><P></P><P>Thank you very much</P><P>Joaquín</P></BODY></HTML> Mon, 06 Jul 2015 11:39:17 GMT https://community.qlik.com/t5/QlikView/Autonumber-in-qvd/m-p/888946#M654286 Joaquin_Lazaro 2015-07-06T11:39:17Z Re: Autonumber in qvd https://community.qlik.com/t5/QlikView/Autonumber-in-qvd/m-p/888947#M654287 <HTML><HEAD></HEAD><BODY><P>Hi Joaquin, Autonumbers creates the hash table in each execution, I think you know that and that's the reason of the question, check this post, maybe it helps you:</P><P><A href="https://community.qlik.com/thread/15953">Autonumber Handling for QVD Optimized Load (via Key Storage)</A></P><P></P><P>Check Rob's and Michael's answers.</P></BODY></HTML> Mon, 06 Jul 2015 12:07:08 GMT https://community.qlik.com/t5/QlikView/Autonumber-in-qvd/m-p/888947#M654287 rubenmarin 2015-07-06T12:07:08Z