Discussion Board for collaboration on QlikView Scripting.
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.
Did you try to comment out NUM in Target table?
Then try left join Customers to Targets.
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?
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
Create Link table else Left Join INVOICETRAC to INVOICEJOUR