topic Re: Qlikview Data Modeling in QlikView

Qlikview Data Modeling

rodrigue_saade — Tue, 28 Jul 2015 22:35:23 GMT

Hi,

I have the data model as in the attached screen. It created a circular reference that i need to resolve.

How can i resolve it?

Note that SMID means SalesManID, and as output i need to build a pivot table which shows the Target and sum of sales by brand and by sales man.

Also note that each item belongs to a brand and the target is by brand.

Re: Qlikview Data Modeling

robert_mika — Wed, 29 Jul 2015 01:44:56 GMT

Did you try to comment out NUM in Target table?

Then try left join Customers to Targets.

Re: Qlikview Data Modeling

rodrigue_saade — Wed, 29 Jul 2015 04:11:07 GMT

So that way, i loose the relation between the brand and the items inside this brand.

But i will be able to get the pivot table i need.

Is that right?

Re: Qlikview Data Modeling

svenkita — Wed, 29 Jul 2015 04:47:24 GMT

customer is already linked to the item table through invoice journal, hence you could delink the customers and Target table by renaming the SMID field in either targets or customers table

Re: Qlikview Data Modeling

sunilkumarqv — Wed, 29 Jul 2015 04:48:35 GMT

Create Link table else Left Join INVOICETRAC to INVOICEJOUR