how to write a set analysis for sql between function

[#1]

I have from date and to date multiselect fileds and i want to show orders between these two date's. How to write it in set analysis?

[NickHoff]

You don't need set analysis, you could use interval match, see the following post.

http://community.qlik.com/blogs/qlikviewdesignblog/2013/04/04/intervalmatch

[JonnyPoole]

Interval match is the more elegant way to do it. 

If you have other reasons, you can capture your FROM and TO dates as variables  ex:

vFromDate:   =min([FromDate])

vToDate:        min([ToDate])

And then in your expression write the SET statement like this:

sum(   {$<[OrderDate={'>=$(vFromDate)<=$(vToDate)'}>}   OrderAmount )

[#4]

Hi,

sum(   {$<[OrderDate={'>=$('start date'<='end date)}>}   OrderAmount: