I have a table of orders where I have the samples that I sent to the customer and the orders that the customer made (I can identify what is sample and what is requested).
I want to know the samples I sent to customers, which customers bought those samples?
In the bank there is no reference key between the sample order and the purchase order of that sample.
I just know that in January I sent the sample "Y" to client "X" and in April that client bought this sample Y.
I do not know if I was clear enough, but I am in any doubt to clarify this problem.
I'm using QlikSense Server Version: 3.2.2
Single table chart.