Modifying My Set Analysis

Mon, 16 Nov 2009 23:11:36 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

Modifying My Set Analysis

Mon, 16 Nov 2009 23:22:43 GMT

I would create a table with a 'N' value where not exists keys for these missing people...

Modifying My Set Analysis

Tue, 17 Nov 2009 21:12:10 GMT

So, if I had three distinct fields (one VM, one DM, and one EM) I would then need three distinct tables holding 'N' values for each one individually, correct?

topic Modifying My Set Analysis in QlikView

Modifying My Set Analysis

Modifying My Set Analysis

Modifying My Set Analysis