I have a table with duplicates. I would like to build something where if the users select "all", Qlikview will show them all the data and if they select "unique", it shows them only the unique data. How would I go about building something like this?
To show all rows in a TableBox or Straight Table, you must have some underlying unique value column you can use as a Dimension in the table. So toggling between showing all rows and consolidating duplicates is a matter of toggling the inclusion of the unique column on/off.
