How to Find sales between the range of date selected in Two different list box having source date from same field ?

[shekhar_analyti]

Hi All ,

How to Find sum of sales between the range of dates selected in Two different list box having source date from same field .

In my qvw i have a single date of sale field . I have created two list box with names as , FROM DATE and TO DATE . But actually both of them refers to single date field .

My requirement is User should be able to select a date from ' FROM DATE ' List Box which should not let selection to happen in TO DATE list box . And hence when user selects a date from TO DATE list box .

Then user should get sum of sales between that range of dates and number of records selected within that range .

Thanks & Regards

Shekar

[shekhar_analyti]

I am able to Get it using alternate state . But i want to know if we can get it without using alternate state

[stigchel · Accepted solution]

Attached a qvw with two solutions, one using variables

Sum({<Date={">=$(=Date(vFromDate))<=$(=Date(vToDefDate))"}>} Sales)

and the second using a second list box in an alternate state.

Sum({<Date={">=$(=Date(Min(Date)))<=$(=Date(Max({ToDate}Date)))"}>} Sales)