topic Set Analysis Multiple Range Search in QlikView

Set Analysis Multiple Range Search

avastani — Thu, 11 Jun 2009 22:14:27 GMT

I saw a post on set analysis with range search posting the answer as

SUM({$<MOTRenewal={">$(=Today())<=$(=(Date(Today()+14)))"}>} FieldToAggregate))

My question is what if I have multiple date ranges that are not continuous. Do I just use a comma to separate and add the other ranges or do I have to do a + SUM() with the other ranges?

thanks in advance

Set Analysis Multiple Range Search

johnw — Fri, 12 Jun 2009 04:39:27 GMT

I believe you just use a + to do the union of two different sets of values, like this:

sum({<MOTRenewal={">=$(=start of first range) <=$(=end of first range)}
+{">=$(=start of second range) <=$(=end of second range)}>}FieldToAggregate)

Set Analysis Multiple Range Search

avastani — Fri, 12 Jun 2009 07:41:43 GMT

that does the trick