topic Re: Circular Reference in QlikView

Circular Reference

pgalvezt — Thu, 08 Nov 2012 17:11:12 GMT

Hello!

I'm trying to avoid the circular reference. When I finally did my final results change I need to get 1895016853 (Debt) without CR.

Thank you!

Re: Circular Reference

MayilVahanan — Thu, 08 Nov 2012 17:22:53 GMT

Change the rename of Periodo as ReportPeriodo in Report_Table.

or join the tables

Hope it helps

Re: Circular Reference

Thu, 08 Nov 2012 17:25:52 GMT

This is very difficult to answer without knowing a little more about your model, and of course (for me anyway) all the columns are in a foreign language so I don't even have any clues as to what the fields are.

You cannot have a circular reference in your data model, this is where table 1 joins to table 2 which joins to table 3 which then joins back to table 1. QWlikview simply cannot deal with this type of relationship and you have to avoid it in whatever way you can. If you explain a bit mroe about your data model I might be able to help.

Re: Circular Reference

pgalvezt — Thu, 08 Nov 2012 17:30:05 GMT

Hi, Mayil Thank you for your reply. But I did that and much more but the filters change and the result that I expect, isn't.

Re: Circular Reference

pgalvezt — Thu, 08 Nov 2012 17:37:37 GMT

Hi Nigel, the idea is do clic in Periodo, Automatically qlikview shows Nov2010 Dic2010 Jan2011 (With this result (1895016853) Thats all. and so on. If you need more details just let me know.

Thank you!

Re: Circular Reference

Gysbert_Wassenaar — Thu, 08 Nov 2012 17:56:55 GMT

As Mayil says, change the rename of Periodo as ReportPeriodo in Report_Table. Then add a listbox for ReportPeriodo and use that to select the reporting period.

Re: Circular Reference

pgalvezt — Thu, 08 Nov 2012 18:05:44 GMT

Hi, Gysber. I did that but everything changed I need to get with one selection 1895016853 (Debt)

Re: Circular Reference

pgalvezt — Thu, 08 Nov 2012 18:52:44 GMT

Any Help?

Thanks!

Re: Circular Reference

Gysbert_Wassenaar — Thu, 08 Nov 2012 19:35:19 GMT

I don't know. I suspect there's something wrong with the dates. In your Sample.qvw I get different sums if select 'ene 2011' in Periodo versus selecting (nov 2010, dic 2010, ene 2011) in Fecha_Protesto. That means some values are not counted so it looks like the join isn't matching all it should match. In the attached file I load the data from your Sample.qvw (renamed locally), drop and recreate ReportTable. Then the sums for both selection methods are the same.

Re: Circular Reference

pgalvezt — Thu, 08 Nov 2012 20:24:40 GMT

Hi, Per month the value is too high! When I select Nov2010 gives 620 million. (Per months is almost the same result) 620, 690, 700 Million but the result that you got is too high. This is an average 1895016853 per months.

Re: Circular Reference

pgalvezt — Fri, 09 Nov 2012 14:36:37 GMT

Any Help? I just need to take the circular reference without change the data.

Thank you!