Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Show products that haven't been sold

Hi

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
Author

Hi,

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