Show only the duplicate values

AppSheet AppSheet Q&A
1

I have document table (Doc) which does allow the same doc_name to be used as a document can have an updated revision. I want to create a slice of this table to show only the duplicate doc_names so the user can check that past revisions have been marked as Superceded.

Any ideas?

2

You could use MAXROW expression to find your latest version from that same Doc_Name.

1 Like
3

Perhaps, instead of a slice, an action of type App: go to another view within this app, with a target expression using LINKTOFILTEREDVIEW(), a prominence of Display inline for the doc_name column, shown only if multiple copies with the same name exist?

1 Like
4

For this same purpose I’ve used @Steve avoid duplicates expression but reversed:

to avoid duplicates the expression is:

ISBLANK(
  FILTER(
    "Table",
    ([_THIS] = [Column])
  )
  - LIST([_THISROW])
)

So the Slice expression to show ONLY DUPLICATES would be:

ISNOTBLANK(
  FILTER(
    "Table",
    ([Column] = [_THISROW].[Column])
  )
  - LIST([_THISROW])
)
1 Like