Discussion Board for collaboration on QlikView Scripting.
I have problem to get the products that haven't been sold in a campaign.
There is a large transaction table and a campaign table. I want to to sort out the products that are in the campaign table but not in the transaction table. The key is kampainId.
I`m not sure , Whether i have understood your query or not.
if i would have understood your query , attached application would be the solution.
Create duplicate kampainId in both transaction table and campign table and compare bothe the id as such i have done in my sample application.
Have a look at my application, you`ll get clear picture.