topic Re: Table - Only show entries with count greater than 1 in App Development

Table - Only show entries with count greater than 1

Andrew_2020 — Fri, 17 Feb 2023 12:34:23 GMT

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])

Re: Table - Only show entries with count greater than 1

henrikalmen — Fri, 17 Feb 2023 07:42:30 GMT

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

if(count(x)>1, DIM)

Re: Table - Only show entries with count greater than 1

Andrew_2020 — Fri, 17 Feb 2023 12:35:55 GMT

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]))

Re: Table - Only show entries with count greater than 1

henrikalmen — Fri, 17 Feb 2023 12:52:39 GMT

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])

Re: Table - Only show entries with count greater than 1

Andrew_2020 — Fri, 17 Feb 2023 12:59:00 GMT

First off, thanks for the continued support.

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

Re: Table - Only show entries with count greater than 1

henrikalmen — Fri, 17 Feb 2023 13:04:55 GMT

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.

Re: Table - Only show entries with count greater than 1

Andrew_2020 — Fri, 17 Feb 2023 13:14:59 GMT

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.