linking problem between database table and excel sheet data

[#1]

Hi team,

i have a sales header and sales detail tables. also a target sales table for salesman in excel. I am supposed to compare actual sales done by salesmen with respect to target from excel. the key to be used is a composite key with the combination of month, brand and salesman number. after linking the tables, i am getting details of salesman which are common in both target and actual. but not the details of target alone. ie; if a salesman hasn't done any sales as per planned for any brand, that value is not shown.

Please help!!!!!

[robert_mika]

Does this help:

Re: Using sum if formula in Qlikview

A similar request to what yo need here

[#3]

could you elaborate. i will attach the sample data for your reference.

[roger_stone]

Take a look at 'NOT EXISTS' for your load.