Sales vs. Quota - No sales, no quota.

[#1]

Hello Community

I am fairly new to Qlikview and currently I'm having problems with how my tables link together.

The problem is the following:

I have one table with sales reps and their respective selling in a month (Sales Table).

I have another table with the sales reps corresponding quota to cover (Quota Table).

I linked both tables using a concatenated key with fields that both tables share in common and everything works, exept the reps that dont have a sale.

When i don't have a sale in the original data, the quota does not appear so I assumed it was because the Quota table did not have a key to link up in the Sales Table.

What I tought that might solve the problem was to put additional lines with the all the Quota keys and assigning a zero sales value to each (so now I have a 100% match), but it does not work, it only links lines that have a value in the Sales table.

Is there something i can do to make qlikview take those lines and complete the link between tables?

Any help is appreciated

Thanks!

[fosuzuki]

Can you post the qvw, or the script, or the data model? It would be easier to understand what is going on...

[#3 · Accepted solution]

Thanks Fernando,

Just this morning I got the problem.

It was my master calendar, altough I had both key lines in both tables, the ones I put to fill the missing sales did not have a date so it was all messed up.

As soon as I put a random date for the month it worked without problems

Thank you!