topic Re: Re: linking problem between database table and excel sheet data in QlikView https://community.qlik.com/t5/QlikView/linking-problem-between-database-table-and-excel-sheet-data/m-p/637310#M233706 <HTML><HEAD></HEAD><BODY><P>could you elaborate. i will attach the sample data for your reference.</P></BODY></HTML> Sun, 18 May 2014 07:48:01 GMT 2014-05-18T07:48:01Z linking problem between database table and excel sheet data https://community.qlik.com/t5/QlikView/linking-problem-between-database-table-and-excel-sheet-data/m-p/637308#M233704 <HTML><HEAD></HEAD><BODY><P>Hi team,</P><P></P><P>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. </P><P></P><P>Please help!!!!!</P></BODY></HTML> Sun, 18 May 2014 06:31:36 GMT https://community.qlik.com/t5/QlikView/linking-problem-between-database-table-and-excel-sheet-data/m-p/637308#M233704 2014-05-18T06:31:36Z Re: linking problem between database table and excel sheet data https://community.qlik.com/t5/QlikView/linking-problem-between-database-table-and-excel-sheet-data/m-p/637309#M233705 <HTML><HEAD></HEAD><BODY><P>Does this help:</P><P><A href="https://community.qlik.com/message/527823">Re: Using sum if formula in Qlikview</A></P><P></P><P></P><P>A similar request to what yo need here</P></BODY></HTML> Sun, 18 May 2014 06:57:32 GMT https://community.qlik.com/t5/QlikView/linking-problem-between-database-table-and-excel-sheet-data/m-p/637309#M233705 robert_mika 2014-05-18T06:57:32Z Re: Re: linking problem between database table and excel sheet data https://community.qlik.com/t5/QlikView/linking-problem-between-database-table-and-excel-sheet-data/m-p/637310#M233706 <HTML><HEAD></HEAD><BODY><P>could you elaborate. i will attach the sample data for your reference.</P></BODY></HTML> Sun, 18 May 2014 07:48:01 GMT https://community.qlik.com/t5/QlikView/linking-problem-between-database-table-and-excel-sheet-data/m-p/637310#M233706 2014-05-18T07:48:01Z Re: linking problem between database table and excel sheet data https://community.qlik.com/t5/QlikView/linking-problem-between-database-table-and-excel-sheet-data/m-p/637311#M233707 <HTML><HEAD></HEAD><BODY><P>Take a look at 'NOT EXISTS' for your load.</P></BODY></HTML> Sun, 18 May 2014 10:48:56 GMT https://community.qlik.com/t5/QlikView/linking-problem-between-database-table-and-excel-sheet-data/m-p/637311#M233707 roger_stone 2014-05-18T10:48:56Z