Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
romeoek
Contributor
Contributor

Set Analysis Expression that displays the Count of Distinct names that appear more than once

Hello I would like to write an expression that only displays the count of records that appear more than once.

i.e :-

Table  
Number  Count
Anne 1
Mark 1
Anne 1
John 1
Peter 1
Peter 1
Peter 1

 

Result

Distinct Number sum(count)>1
Peter 3
Anne 2

 

The script I am currently using is = Count ({<Value = {"= Sum (Count) > 1"}>} Distinct Name) but does not give the correct result

3 Replies
romeoek
Contributor
Contributor
Author

I have also tried this script but still does not give the correct result

=Count( if( (aggr(Sum(count_names),name)) > 1, name ) )

adrienL
Contributor
Contributor

You could try this on maybe:

dimension : if(count(Names)>1, Names)
measure : count(Names)

romeoek
Contributor
Contributor
Author

its's a measure and count(names) would count all the names that appear and not the ones that appear more than once