Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist II
Specialist II

Autonumber in qvd

Hello:

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

Joaquín

1 Solution

Accepted Solutions
Highlighted

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

1 Reply
Highlighted

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