Qlik Community

App Development

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

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
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