Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

mambi
Contributor III

set analysis count

Hi, I have a the following structure:

ContactidTargetDATE
1A2000
2
2000
3B2000
4C2000
5A2000
1
2000
6C2000
2
2001
4B2001
5
2000
3
2000
4
2003

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  :


Targetcount
A2
B2
C1

1

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

Targetcount
A2
B2
C2

6

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

Thanks;

Tags (1)
Community Browser