topic Re: Circular Reference in QlikView

Circular Reference

pgalvezt — Thu, 23 Aug 2012 18:56:52 GMT

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

Re: Circular Reference

pgalvezt — Thu, 23 Aug 2012 19:33:35 GMT

Any Help?

Thank you

Re: Circular Reference

Bill_Britt — Thu, 23 Aug 2012 20:14:30 GMT

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

Bill

Re: Circular Reference

pgalvezt — Thu, 23 Aug 2012 20:19:14 GMT

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.

Re: Circular Reference

Bill_Britt — Thu, 23 Aug 2012 20:25:37 GMT

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

Re: Circular Reference

pgalvezt — Thu, 23 Aug 2012 20:42:47 GMT

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

Re: Circular Reference

Bill_Britt — Mon, 27 Aug 2012 12:27:58 GMT

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

Re: Circular Reference

pgalvezt — Mon, 27 Aug 2012 13:51:24 GMT

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.