Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sums for expression in straight table?

SalesNameCustomerStart DateAction DateQuickMediumLong

Jack

ABC1/5/20121/6/2012100
JackABC1/5/20121/25/2012001
JillXYZ1/5/20121/5/2012100
JillXYZ1/5/20121/6/2012100
JackABC1/15/20121/25/2012000
JamesBBB1/15/20121/29/2012010
Here's my issue: I have a group of ten salespeople. I want to measure how quickly they respond when they get a lead. I have a straight table, as shown above. The fields "Quick", "Medium", and "Long" are calculated using an expression (NetWorkDays). I want, for each rep, to do a count distinct of company, a count distinct of Start Date per company, and a count of Quick, Medium, and Long. This will, I hope, tell me for each rep the number of companies they are working, the number of opportunities they have, and how many total calls they have made that fall into each of the Quick, medium, and long buckets. I've tried doing this as a pivot table, but it won't let me sum on the expressions, and when I tried a partial sum for Company, it didn't show any sums for Quick, Medium, or Long. I should think this would be simple - it'd take me a minute in Excel - but clearly I'm missing something here. Any help?
0 Replies