Discussion Board for collaboration on QlikView Scripting.
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.
The first one is only recharged when a change in data model is necessaty.
The second is recharged the first day of each month
The third is executed for 2nd until 31th
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.
My doubt is which is the best way or best practice to include this Autonumber() or other function in the qvd generators ?
Thank you very much
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:
Autonumber Handling for QVD Optimized Load (via Key Storage)
Check Rob's and Michael's answers.
View solution in original post