Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

New Contributor III

Only add the orders that are contained in the sample request

Hello people,

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.

Community Browser