Circular reference in purchase and sale orders

[#1]

Hello

I am new in Qlik Sense and in this forum,

I have this situation:

I need to compare sales and purchases orders by product in a time periods (years, months)

I have a table with

Sales:

OrderID,

ProductID,

SalesDate,

....

Purchases:

PurchaseOrderID,

ProductID,

PurchaseDate,

....

I have two Calendar tables (with resident option) and in both of then I have a field Year to try to compare sales and purchases.

However I have a circular reference, I can I resolve it?

Thanks,

[swuehl]

Circular References

Why You sometimes should Load a Master Table several times

Tutorial - Using Common Date Dimensions and Shared Calendars

[srchilukoori]

Hi Pedro,

Try renaming one of the fields, that will clear the circular reference.

[#4]

Thanks srchilukoori,

My trouble es that when I rename the field (v.g. rename Year like YearPurchase) I cannot do a graphic showing purchases and sales for one year and one product.

[srchilukoori]

Pedro,

see if you can create an Island table for time, and use that as a dimension. You would also have to change the calculations.

[srchilukoori]

A better alternative is to concatenate the two fields and adding a Table name field to differentiate the data in each table.

[Anonymous]

Hi Pedro,

Maybe post screenshot of Datamodel from Table viewer,will be easy to help.

[qlikviewwizard]

Hi,Can you provide the whole script or sample file with the data.

It is highly difficult to provide the solution with imagination with your provided information

[sll]

Have you looked at Link tables in Qlik?

http://www.analyticsvidhya.com/blog/2014/12/remove-synthetic-key-concatenation-link-table-qlikview/

As suggested, you can concatenate however that may require you to write customer measures with Set Analysis. Link tables result in cleaner data model as well as easier implementations.

[sll]

Another good Qlik blog post:

Concatenate vs Link Table

Asim