Circular Reference

[pgalvezt]

Im having problems with Cc_Cli Field but I need this field for call the three tables plus the period. When I renamed periodo everything is fine but when I renamed Cc_Cli reference Circular is present.

How can I Avoid this if what I want is to do clic on Period and Cc_Cli (Customer Code).

Thanks

[pgalvezt]

Any Help?

Thank you

[Bill_Britt]

Decide which one you want to use as the key field and then rename the other.

Bill

[pgalvezt]

Hi Bill, I need both of them Period and CC_Cli. Is this possible or do I have to do another sheet with "Castigo"?

Thanks.

[Bill_Britt]

You can still load both, just rename one. You can't use them both as key fields.

[pgalvezt]

I renamed them but now I have this. Look at the jpg file please.

[Bill_Britt]

Here is your problem. QlikView can only have one key field linking two tables together. In you picture you can see that you have two (Periodo and CC_CLI). This cause QlikView to generate a Synthetic Key to link the tables together. This can be resource heavy and cause your application to run very poorly.

Bill

[pgalvezt]

Thank you Bill for your reply, Can you help me whit this? How can I avoid this issue. What I want is show just in one clic the period and other clic the customer commerce (Cc_Cli) I can't have 2 Cc_Cli.

Thank you.