Table - Only show entries with count greater than 1

[Andrew_2020]

I want to ONLY show entries in a table with counts greater than 1.

How do I remove the entries less or equal to 1, so we are only seeing anything above the count of 1?

Using a table and is in QlikSense.

Dimension is [Sales Primary Key] and measure is Count([Sales Primary Key])

[henrikalmen]

If your dimension i called DIM and your measure is count(x), you could use this calculated dimension:

if(count(x)>1, DIM)

[Andrew_2020]

Dimension is "Sales Primary Key" and the Measure is Count([Sales Primary Key]). The solution you provided results in the below, which is still listing the entries less or equal to one.

IF(Count([Sales Primary Key])>1,Count([Sales Primary Key]))

[henrikalmen]

You wrote the formula as the measure, but you should write it as a calculated dimension. Replace your dimension with this:
=IF(Count([Sales Primary Key])>1,[Sales Primary Key])

[Andrew_2020]

First off, thanks for the continued support.

When I use it as a dimension, it comes back telling me it is an invalid dimension.

[henrikalmen · Accepted solution]

Ah, yes - that actually makes sense. Try this instead as the calculated dimension:

=IF(aggr(Count([Sales Primary Key]), [Sales Primary Key])>1,[Sales Primary Key])

I hope I wrote it right this time.

[Andrew_2020]

My first thought was "Didn't I already try this from all my research on these forums?".

My second thought was "It worked?!" 😁

That was the solution and now the list ONLY shows exactly what I was expecting. Thank you so much for the help and support.