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.
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.
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.
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.
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.
