Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Show products that haven't been sold


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.

Please help

1 Reply
Not applicable

Show products that haven't been sold


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.

Good luck Yes

- Sridhar

Community Browser