topic Re: how to write a set analysis for sql between function in QlikView

how to write a set analysis for sql between function

Wed, 01 Oct 2014 20:14:37 GMT

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 — Wed, 01 Oct 2014 20:19:05 GMT

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

JonnyPoole — Thu, 02 Oct 2014 00:09:24 GMT

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 )

Mon, 25 May 2015 11:12:10 GMT

Hi,

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