I hope you can help me with a topic i know has been covered off in different ways.
First of all, thanks to all the people who have responded in the past to Venn Diagram queries a lot of this as been mega helpful and taught me lot of useful Set Analysis. The Google Venn is a very powerful API and i hope one day QlikTech will implement it into a release.
So, on to my issue.
I have a successfull Venn diagram in my application, and i understand the variables which are needed to be passed though. the problem i am having is how to calulcate the intersects of my data.
I have a simple yet large dataset of 13M records. This is a fact table of outbound Campaigns. EG:
[BP] [Campaign_Name] [Date]
BP is the customer ID.
My application only allows the venn diagram to work only on 3 selected letters (there could be 50 to choose from). The first three variables of the Venn API are the total size of each circle ive called these , i've used a combination on variables to calulate this.
Current selection variables (This will return the String of the selected campaign names)
Total count variables (Using the variables above to give me a count of the BP's)
The next part i'm struggling on. The above is really my limit on Set Analysis, so i really want to understand how from one table can i return an intersect from a selection A+B B+C C+A - the customer ID is the primary key here.
Is there an expression i can use in a variable to return the above intersects.
Thanks again, i had little parts of that expression dotted around, but its knowing how to apply it or put it in place. this set analysis is proving quite powerfull, the developer course i went on didnt cover it a huge amount.