Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Not applicable

linking problem between database table and excel sheet data

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!!!!!

3 Replies
Highlighted

Re: linking problem between database table and excel sheet data

Does this help:

Re: Using sum if formula in Qlikview

A similar request to what yo need here

Highlighted
Not applicable

Re: Re: linking problem between database table and excel sheet data

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

Highlighted
Contributor III

Re: linking problem between database table and excel sheet data

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