topic Re: Qlikview datamodel problem in QlikView

Qlikview datamodel problem

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Qlikview datamodel problem

el_aprendiz111 — Tue, 07 Mar 2017 01:22:26 GMT

Hi Omer

Has sample information

Re: Qlikview datamodel problem

qlikviewwizard — Tue, 07 Mar 2017 02:32:47 GMT

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

Re: Qlikview datamodel problem

eduardo_sommer — Tue, 07 Mar 2017 03:01:41 GMT

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

Re: Qlikview datamodel problem

muthukumar77 — Tue, 07 Mar 2017 05:10:05 GMT

Hi,

You can concatenate the 2 tables.

Re: Qlikview datamodel problem

Wed, 08 Mar 2017 13:54:04 GMT

Hi Everyone ,

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

Appricated this.

Omer