circular reference

[#1]

Hi all,

I have a problem with my data model that probably everybody that work with Qlikview have jet, I need a circular reference!!!

I'm working with a database with this data model:

"Table 1" have a 1 to many relation with "Table 2". "Table 2" have a 1 to many relation with "Table 3". I need to make analisys in Qlikview through this relations, for example, I need to know the total "Amount table 2" related with each record of the "Table 1", the same case between "Table 1" and "Table 3", and "Table 2" and "Table 3".

Ok, I can do this, but also need to make analysis of "Amount table 1", "Amount table 2" and "Amount table 3" by the fields "Dimension 1" and "Dimension 2". I have this fields en every table and I need to aggregate values by this fields.

There are any way to maintain "Dimension 1" and "Dimension 2" tables not linked with the data model and use it to create pivot tables with fields of this tables as Dimensions and take values of the other linked tables with expresions like this?

Sum(

{<

[Table1.Dimension 1] = {$(=ONLY([Dimension 1]))}

>}

"Amount Table 1"

)

The previous expresion not works.