topic Calendar creation using event table in QlikView

Calendar creation using event table

transalp89 — Wed, 08 Apr 2015 14:01:34 GMT

Hello,

Still a beginner in advanced scripting, I have the following problem to solve:

I want to create a calendar wich for each day the production planned evry day.

for that I have a table as input giving for each change the date and the new production rate.

You have attached the excel file with a first sheet which is the input and the second one is the wanted result.

thanks to help me

Wed, 08 Apr 2015 16:36:45 GMT

Hi Andre,

look at the attachment, you can find the script to generate the data table as you have requested

To reload the data, changes the patch file containing the data

Regards

Gennaro

transalp89 — Wed, 22 Apr 2015 12:52:03 GMT

Thanks a lot Gennaro, it's exactly what I need! sorry for the late response !!

Regards

Andre