Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Qlikview datamodel problem

Hi Everyone,

I have a question , I want to show sales vs Quotas of sales persons.

I have two tables

1-Sales [ Period, Sales Person, Brand , Sales Amount]

2-Quotas [Period,Sales Person, Brand ,Quota]

I created a common key  based on Period, Sales Person, Brand such as Period-Sales Person- Brand and so far everything works ok.

My problem is, when I create this key, only records with matching Ids are shown and not matching Ids are not calculated

for Ex: Quota table creates 100 ids but Sales table creates 80 id (un sold /brands)

When I created a pivot out of this, both Quota and Sales Amounts are empty for the user how hasn't sold that brand yet.

I have searched on the site but all Examples I found are based on 1-1 Id matches.

Thanks omer

5 Replies
el_aprendiz111
Specialist
Specialist

Hi Omer

Has sample information

qlikviewwizard
Master II
Master II

It is pretty good to understand your issue if you provide sample data.

eduardo_sommer
Partner - Specialist
Partner - Specialist

Hi,

Try to load both the Sales and the Quotas on the same table, using concatenate load. Doing this, you can use Period, Sales Person and Brand as dimensions and Sales Amount and Quota in expressions.

Eduardo

muthukumar77
Partner - Creator III
Partner - Creator III

Hi,

You can concatenate the 2 tables.

Muthukumar Pandiyan
Not applicable
Author

Hi Everyone ,

Eduardo's and Muthukumar's reply about concatenating two tables worked . Thanks for your help.

Appricated this.

Omer