Date Range

Wed, 02 Mar 2011 23:52:05 GMT

I need help on the below set analysis.

I have 300 stores with each having different reset days. I imported an excel file so i can have the store number and corresponding reset date as an field.

I am trying to calculate total sales since the store was reset.

I have a field called [Reset Date] which is the list of all stores with their corresponding reset date.

for example: store 9999 was reset on 1/31/2011, today is 3/1/2011, my goal is to calculate the total sales between 1/31/2011-3/1/2011.

This is the formula i am using to calculate how many days its been since the store is reset.

= (Today()-'1/1/2011') - Date(([Reset Date]-'1/1/2011')-1,"dd,mm,yyyy") , and it works

The part i need help is how can i sum a range

=sum({< CalendarDate={[Reset Date]+(Today()-'1/1/2011') - Date(([Reset Date]-'1/1/2011')-1,"dd,mm,yyyy"))>}Sale)

Baically the sum of the sales of each store since its been reset

Did anybody come accross the same problem?

topic Date Range in QlikView

Date Range