Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

joaquinlr
Valued Contributor 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

Re: Autonumber in qvd

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.

1 Reply

Re: Autonumber in qvd

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.