Intersection of 2 datasets

quilldew — Mon, 02 Dec 2019 16:43:47 GMT

Hi,

I've asked this question in one manner, and not found a solution yet, so lets try a different tack 😂

I have a table that appears similar to below:

And i'd like to be able to create a table that only shows the referrals to a non-Urgent Service, where the UserID has also had contact with an Urgent Service, and where the Contact_Date for that Urgent Service is after the RefDate of the referral of the non-Urgent Service.

So based on the above table it would show:

This is a simple version of my actual tables, what i'm essentially trying to do is using p() create a couple of datasets, then intersect them, and then perform =if()'s on the resulting table.

Where I'm running into issues is the limitation on one expression within the p(), adding any other set analysis treats the additions as an 'OR'.

Re: Intersection of 2 datasets

siddheshmane — Sun, 22 Dec 2019 12:24:19 GMT

Could you share a sample data.

topic Re: Intersection of 2 datasets in QlikView

Intersection of 2 datasets

Re: Intersection of 2 datasets