Qlik Community

Qlik Sense App Development

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

gleybson_calyx
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