set analysis count

mambi — Thu, 02 Aug 2012 13:36:00 GMT

Hi, I have a the following structure:

I am trying to get this using an expression :

count the number of Contact IDs for each target, like this :

IF A CONTACT HAS ONE TARGET COUNT ONLY THE 1ST NON EMPTY

IF A CONTACT HAS MANY TARGETS (ex: CONTACTID => 4) COUNT ONLY THE 1ST NON EMPTY WITH LATEST DATE

ALSO, I NEED TO COUNT Contact IDs WITH NO TARGET

so the results would be :

if i use only count(target) i'm getting this :

I am trying to get this done with Set analysis but no results :-((:

Thanks;

topic set analysis count in QlikView