Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
We value your feedback – take our 5-minute QlikView modernization survey
cancel
Showing results for 
Search instead for 
Did you mean: 
quilldew
Creator
Creator

Intersection of 2 datasets

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:

image.png

 
 

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:

image.png

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'.

1 Reply
siddheshmane
Creator
Creator

Could you share a sample data.