Show duplicate rows based on a user selection selection of columns

[craig_VAGO]

I have a straight table and I need to be able to show rows based on a user's selection of which columns to include in identification of duplicates.

For example, in the table below:

• if the user selected only ID, all rows would be shown,
• if the user selected ID and Field1, rows 1 and 2 would be shown,
• if the user selected ID, Field1 and Field 2, rows 1 and 2 would be shown,
• if the user selected ID and Field 2, all rows would be shown.

In my actual problem I'll need to use 6 columns in the possible combinations. Is there any way to accomplish this with reasonable performance? I had planned to use toggle buttons to turn column selections on/off and have that flipping a variable linked to each.

I'm fairly new to Qlik Sense and hoping a veteran can help with this problem, thanks in advance!