topic Table referenced by to others in QlikView https://community.qlik.com/t5/QlikView/Table-referenced-by-to-others/m-p/980109#M646985 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have the following model:</P><P><IMG alt="Screen Shot 2015-10-01 at 11.34.03 AM.png" class="jive-image image-1" src="/legacyfs/online/100659_Screen Shot 2015-10-01 at 11.34.03 AM.png" style="height: auto;" /></P><P style="font-size: 13.3333px;">Cliente = Client (A person)</P><P style="font-size: 13.3333px;">Vendedor = Sales rep </P><P style="font-size: 13.3333px;">Notafinal = Order</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Problem: </P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">1 Client (CLIENTE) has one main Sales Rep (VENDEDOR), but the Order (NOTAFINAL) can be submitted by a different Sales Rep (VENDEDOR). Today, base on the current model, I can only show the sales based on the main Sales Rep, not based on the actual Sales rep that submitted the order. How can I adapt the model in order to show the orders both by the main Sales rep and by the one that submitted the order?</P><P></P><P>Sorry if I'm being too vague. </P><P></P><P>Att,</P></BODY></HTML> Thu, 01 Oct 2015 15:05:50 GMT guilhermetiscos 2015-10-01T15:05:50Z Table referenced by to others https://community.qlik.com/t5/QlikView/Table-referenced-by-to-others/m-p/980109#M646985 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have the following model:</P><P><IMG alt="Screen Shot 2015-10-01 at 11.34.03 AM.png" class="jive-image image-1" src="/legacyfs/online/100659_Screen Shot 2015-10-01 at 11.34.03 AM.png" style="height: auto;" /></P><P style="font-size: 13.3333px;">Cliente = Client (A person)</P><P style="font-size: 13.3333px;">Vendedor = Sales rep </P><P style="font-size: 13.3333px;">Notafinal = Order</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Problem: </P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">1 Client (CLIENTE) has one main Sales Rep (VENDEDOR), but the Order (NOTAFINAL) can be submitted by a different Sales Rep (VENDEDOR). Today, base on the current model, I can only show the sales based on the main Sales Rep, not based on the actual Sales rep that submitted the order. How can I adapt the model in order to show the orders both by the main Sales rep and by the one that submitted the order?</P><P></P><P>Sorry if I'm being too vague. </P><P></P><P>Att,</P></BODY></HTML> Thu, 01 Oct 2015 15:05:50 GMT https://community.qlik.com/t5/QlikView/Table-referenced-by-to-others/m-p/980109#M646985 guilhermetiscos 2015-10-01T15:05:50Z Re: Table referenced by to others https://community.qlik.com/t5/QlikView/Table-referenced-by-to-others/m-p/980110#M646986 <HTML><HEAD></HEAD><BODY><P>One way is to load the vendedor table twice and rename the key field of the second table so that second table links with the submitting sales rep.</P></BODY></HTML> Thu, 01 Oct 2015 16:56:05 GMT https://community.qlik.com/t5/QlikView/Table-referenced-by-to-others/m-p/980110#M646986 Gysbert_Wassenaar 2015-10-01T16:56:05Z