2 Replies Latest reply: Dec 14, 2012 3:32 PM by Carlos Bujanda RSS

    Sales vs. Quota - No sales, no quota.

      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!