topic Insert record in table in QlikView

Insert record in table

Wed, 07 Sep 2011 09:05:52 GMT

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

Wed, 07 Sep 2011 09:20:31 GMT

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.

Wed, 07 Sep 2011 09:24:12 GMT

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 — Wed, 07 Sep 2011 10:01:27 GMT

Hi,

Please check in my attached file.

Do let me know, if this one help you.

Regards,

Sokkorn

Wed, 07 Sep 2011 10:26:29 GMT

This might be an easier way.

Regards,

Kiran.

Wed, 07 Sep 2011 15:29:04 GMT

Thank You very much!!!

It's perfect!!!

I was what I want