allocate an aggregated value

[#1]

Hello

I have a sumed value , field value, (see table 1 in the excel file attached below) , and i need to allocate it according to the same dimensions but also on the list of working days betwwen start-date and end-date (allocating value/[Nbdays]) and then sum it

(see table result). for the other days (wekends and holidays) we'll just put zero instead.

I have already a calendar with a flag (if the date is a workingday than 1 else 0).

thanks for your help

[hic]

You can do this by using a while-loop, where the while loops between start date and end date. Then you can create a daily amount based on initial number and how many days you have in this range,

See more on http://community.qlik.com/blogs/qlikviewdesignblog/2013/02/12/reference-dates. Look especially at how the field DailyAmounts is created.

HIC