0 Replies Latest reply: Aug 4, 2017 1:44 PM by Gleybson Fernandes RSS

    Only add the orders that are contained in the sample request

    Gleybson Fernandes

      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.