Regards QlikView Community
This message is to tell them about a problem I have with a model (attached the picture) in which I had to duplicate the table "Projecto" and the copy called "ProyectoPresupuesto" and without any kind of connection between these two. The reason why this was done was because if I was alone, generated a circular reference, because it would have two possible routes to get to the table "Transacciones. "
With this new model that I have a problem when I make a pivot table in which the dimensions must be the current year, the company which owns the "Proyecto" and the name "Proyecto. " The 3 expressions are: A cumulative total number of projects, a cumulative sum of the number of budgeted projects and the difference between these two. The problem is that I have two possible dimensions which is a Project Name (ProyectoPresupuesto.Nombre (Table "ProyectoPresupuesto") and NombreProyecto "Proyecto"). I tried various forms of SetAnalisys but I can not get the result when I select a project Specs or deselect everything. The expressions are in other graphic and they are okay.
![error loading image](/legacyfs/online/-4019_sourceID:4019)