Skip to main content

# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW
cancel
Showing results for
Search instead for
Did you mean:
Specialist

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

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

1 Solution

Accepted Solutions
Partner - Master

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)

2 Replies
Specialist
Author

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

Partner - Master

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)

Community Browser