Filtering A Set Analysis Calculation

Mon, 16 Nov 2009 23:08:20 GMT

I have several 'Times Contacted' fields that are banded into ranges and I am determining what the indexes are for those people who are Do Not Contacts versus those who are not (to determine what is the over/under on # of contacts). I have the following Set Analysis statement to figure out what the index is:

(SUM({$<Do_Not_Contact={'Y'}>} Customer_Counter) / SUM({$<Do_Not_Contact={'Y'}>} TOTAL Customer_Counter)) / (SUM({$<Do_Not_Contact={'N'}>} Customer_Counter) / SUM({$<Do_Not_Contact={'N'}>} TOTAL Customer_Counter)) * 100

This works great on the 'Overall Times Contacted' table because every record has a dimensional value of at least 1. However, when I get to vertical-specific report (ie Times Contacted VM) I have dimensions that are NULL because they may not have been contacted via phone. How should I modify my Set Analysis to knock out those NULL values, as they skew my results?

Thanks,

Jeff

topic Filtering A Set Analysis Calculation in QlikView

Filtering A Set Analysis Calculation