Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

eustisab
New Contributor III

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

Re: count of count greater than a number

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

eustisab
New Contributor III

Re: count of count greater than a number

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

arulsettu
Honored Contributor III

Re: count of count greater than a number

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

eustisab
New Contributor III

Re: count of count greater than a number

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)