For Table Viewer which type of relation ship is used?

[amars]

Hi all,

I am developing some dashboard in which I use alias to create relation ship between table's , which I can see through Table Viewer but I am not sure about what type of relation INNER , OUTER it uses for the join , because it is not giving me the required result. So if someone can tell me that. Also is it prefarable to join the table's this way in QlikView, your suggestion's on that.

Thanks in advance.

Regards

Amar[:(]

[Anonymous]

Amar,
QV application internal structure is not a relational database, so your question is not exactly pertinent. In fact, if you have a field "Field1" in Table1 and in Table2, it is one and the same field in QlikView app.
For logical purpose, you can think of the links as "full outer join".

[amars]

Thank's Michael,

I am having a circular relation that is why I am not getting the required relation may be, I will try & solve that.

Thanks again

Regards,

Amar

[Anonymous]

Amar,
I'm sure you'll find enough info here how to resolve circular relationships. Hint - search for the "synthetic keys"