Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Set Analysis Sum Distinct

I am trying to sum the difference between two date values for unique combinations of Name, Date1, and Date2

I have data of the format:

NameDate1Date2

Chuck

1/1/121/3/12
Sam1/1/121/3/12
Sam

1/3/12

1/5/12

Sam

1/3/121/5/12
Sam1/3/121/5/12

And I want to sum Date2 - Date1 for unique combinations. In this case, Chuck would get 2, the first line of Sam would get 2, and the next 3 lines of Sam are all identical so would count once and be 2 for a total of 6.

Currently all I can get is 2+2+2+2+2=10

Anybody know how to code this?

3 Replies
Highlighted
MVP
MVP

Maybe like

=sum( aggr( Date2-Date1, Name, Date2, Date1))

Highlighted
MVP
MVP

swuehl,

perhaps the aggr with nodistinct?

Highlighted
Not applicable

Worked great, and my coworker thought I was a genius for coding it this way!