Button to filter data from main table based on entries in blacklist table
Hi,
I am currently stuck with a Qlik Sense app in which I want to give the user the option to, with the click on a button, exclude certain data that matches with data stored in another table.
In a simplified way, I have a main table with product categories and products and want to implement a button so that rows that match the blacklist table can be included or excluded. Like a "not in" that can be toggled on or off. Both tables are created in Qlik Sense's load editor through SQL statements.
main_table:
SQL
select
category, product
from database;
blacklist:
SQL
LOAD * inline [
category, product
tools, hammer
tools, nail
];
Can someone give me a hint how to approach this? Would be cool if there would be a way that doesn't require me to change all visualizations in the existing app.
