allocate an aggregated value

Wed, 07 May 2014 09:31:41 GMT

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

Re: allocate an aggregated value

hic — Wed, 07 May 2014 09:37:17 GMT

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

topic Re: allocate an aggregated value in QlikView

allocate an aggregated value

Re: allocate an aggregated value