Create a Qlik Sense table that shows the Inverse of the table next to it
Good Day,
I am struggling with a problem. I have a table that shows all customers allocated to an Agent e.g Franje who have made a purchase Netsales. This is fairly easy as I simply create a table with Customer & netSales and Filter by Franje. The next step is slightly harder.
I would like to build a table next to this one which shows the inverse, these are Customers the Agent still needs to contact.
I have a column Agent which has a number of different agents, A column for Customer and a Column for NetSales. I believe I would need some kind of formula which holds its state, so that no matter the selection applied it will remember the entire list, subtract those who have purchased, and return the remainder.
