List Detail Date in Date Range

[Sokkorn]

Dear All,

I am a new with QlikView. And now I have problem with Date.

Suppose that I have data source as below:

Now I want to transform date like:

Anyone help me how to write script to get data like table Transform above.

Please add your idea in the attached file.

Thanks in advance!

Best Regards,

Sokkorn Cheav

[llauses243]

Hi,

This is my offer, see image & zip attached

Good luck, Luis

[Sokkorn]

Hello Luis,

Thank for your prompt respone.

I think it better than this, If can use only one table.

[lironbaram · Accepted solution]

hei you can try this one

may be it'll helps you

[Sokkorn]

Dear RoiUser,

This is the one that I need.

Many for your help.