Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

srikanthsri1
Valued Contributor

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

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

 

3 Replies
shaik_basha
Contributor III

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

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

srikanthsri1
Valued Contributor

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

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

srikanthsri1
Valued Contributor

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

i'm i clear on this ??

Any suggestion would be helpful

Community Browser