Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

cancel
Showing results for 
Search instead for 
Did you mean: 
craig_VAGO
Contributor
Contributor

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.

qlik example table.png

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!

Labels (2)
0 Replies