Include values in set, but exclude when excluded from selection?

Thu, 12 Jun 2014 18:39:21 GMT

Hi, all.

I have a basic count of calls when a "type" value is set to Residential:

SUM({<$(=vDateAlias)={">=$(=vRangeDate1)<=$(=vRangeDate2)"}, callType={'Residential'}>}[Call Count])

This works fine. However, when I make a selection that does not include this type (Such as "Business, Credit, Apartment"), the count does not change; it still shows the count of calls that have a type of Residential.

I tried changing to use the current selections as the base, but the number does not change:

SUM({$<$(=vDateAlias)={">=$(=vRangeDate1)<=$(=vRangeDate2)"}, callType={'Residential'}>}[Call Count])

So, if I have these counts:

Residential = 200

Business = 300

Credit = 400

Apartment = 500

And make no selections, I would expect the above sum to show 200, which it does. If I make a selection of Apartment, I would expect the number to change to 0. It stays at 200.

How do I make the set respect both the Residential count, and current selections?

Thanks!

Re: Include values in set, but exclude when excluded from selection?

Anonymous — Thu, 12 Jun 2014 19:47:21 GMT

If i got the requirement right, here is what you need:

SUM({<$(=vDateAlias)={">=$(=vRangeDate1)<=$(=vRangeDate2)"}>} if(callType='Residential',[Call Count]))

topic Re: Include values in set, but exclude when excluded from selection? in QlikView

Include values in set, but exclude when excluded from selection?

Re: Include values in set, but exclude when excluded from selection?