Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

count of count greater than a number

I have 3 columns:

   

SD.Customer Formatted Numberoriginal dimension (caller number)
Customer Contact IDbasically an expression to correct the format=IF(Index([SD.Customer Formatted Number],'tel:')>=1, KeepChar([SD.Customer Formatted Number], '+0123456789'), IF(index([SD.Customer Formatted Number], 'sip:')=0, [SD.Customer Formatted Number], mid([SD.Customer Formatted Number], 5)))
Count([SD.Customer Formatted Number])count of calls

Count([SD.Customer Formatted Number])

fcr sample.JPG

Now, I want to count the number of callers that called more than once (email add not included)

Desired Result:

  

DateRepeat callers
5/8/20182
5/9/20183
4 Replies
Anil_Babu_Samineni

Can you describe why those 2 rows only for 8/5/2018 ??

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Anonymous
Not applicable
Author

only those 2 callers have called more than once. (Please note that email add should not be counted as caller)

arulsettu
Master III
Master III

but those numbers are appeared only once in the file you shared

Anonymous
Not applicable
Author

yeah.. i've already count the number of times they appeared so im now referencing on the last column "Count([Sd. formattednumber]) (as the number of times the caller called)