topic Re: Need to do Aggregation at script level over a range of date for all weeks in QlikView

Need to do Aggregation at script level over a range of date for all weeks

Anonymous — Mon, 18 Feb 2013 17:30:33 GMT

Hi All,

This might be a simple but i'm not sure how to do this ??

i want to aggregate values for each week and only for certain range of dates (within that week )......

say suppose my date is (1/27/2013) it should sum (gallon) for report date ranging from (1/21/2013 - 1/27/2013)

need this in script (backend) ???

here my data in excel and my application ...

let me know if i'm not clear?

and please give your valuable suggestion

Anonymous — Mon, 18 Feb 2013 18:12:23 GMT

hi,

i need some claification,how you bucket days you want to take as one week,can you please give me some equiement claification.

Regards

Anonymous — Mon, 18 Feb 2013 18:19:22 GMT

The field date is a just showing sunday of every week (i.e just one week )

for given (date) there many report dates ..now we need to map it in way that date should only have report date of that week range and do sum(gallon)

let me know if i'm not clear on this

Anonymous — Mon, 18 Feb 2013 19:40:00 GMT

i'm i clear on this ??

Any suggestion would be helpful