Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
guilhermetiscos
New Contributor II

Table referenced by to others

Hello,

I have the following model:

Screen Shot 2015-10-01 at 11.34.03 AM.png

Cliente = Client (A person)

Vendedor = Sales rep

Notafinal = Order

Problem:

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?

Sorry if I'm being too vague.

Att,

1 Reply

Re: Table referenced by to others

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.


talk is cheap, supply exceeds demand
Community Browser