Insert record in table

[#1]

Hello everybody,

I'm not good in english but I tried to explain my problem

I have a table like this:

Code  Date-Beging    Date-Final

1        01/01/2011    03/01/2011

2        05/03/2011    05/03/2011

And I want (do in script)

Code  Date           Compteur

1     01/01/2011    1

1     02/01/2011    1

1     03/01/2011    1

1     05/03/2011    1

Have you any idea please to realised this in Qlikview?

I use QV 10 SR3.

Think you very much for your help

[#2]

What is the logic to create second table from first? Can you tell how these records are to be created (or transformed from the first table)?

Regards,

Kiran.

[#3]

I want do statistic of the during date.

I need to have one row by day for each code for compare with other information which are stored one information by date!

i'm sorry for my english and i hope you understand me...

thank you for your help

[Sokkorn · Accepted solution]

Hi,

Please check in my attached file.

Do let me know, if this one help you.

Regards,

Sokkorn

[#5]

This might be an easier way.

Regards,

Kiran.

[#6]

Thank You very much!!!

It's perfect!!!

I was what I want