Show duplicate rows based on a user selection selection of columns
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!