Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
rodrigue_saade
Contributor

Qlikview Data Modeling

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.

4 Replies

Re: Qlikview Data Modeling

Did you try to comment out NUM in Target table?

Then try left join Customers to Targets.

rodrigue_saade
Contributor

Re: Qlikview Data Modeling

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?

svenkita
Contributor II

Re: Qlikview Data Modeling

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

sunilkumarqv
Valued Contributor II

Re: Qlikview Data Modeling

Create Link table  else Left Join INVOICETRAC to INVOICEJOUR

Community Browser