topic Problem with Accumulated PivotTable 2 Dims in QlikView https://community.qlik.com/t5/QlikView/Problem-with-Accumulated-PivotTable-2-Dims/m-p/199299#M58285 <HTML><HEAD></HEAD><BODY><P>Regards QlikView Community</P><P>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. "</P><P>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.</P><P><IMG alt="error loading image" class="jive-image error-loading-image" src="https://community.qlik.com/legacyfs/online/-4019_sourceID:4019" /></P></BODY></HTML> Tue, 05 Apr 2011 22:15:13 GMT 2011-04-05T22:15:13Z Problem with Accumulated PivotTable 2 Dims https://community.qlik.com/t5/QlikView/Problem-with-Accumulated-PivotTable-2-Dims/m-p/199299#M58285 <HTML><HEAD></HEAD><BODY><P>Regards QlikView Community</P><P>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. "</P><P>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.</P><P><IMG alt="error loading image" class="jive-image error-loading-image" src="https://community.qlik.com/legacyfs/online/-4019_sourceID:4019" /></P></BODY></HTML> Tue, 05 Apr 2011 22:15:13 GMT https://community.qlik.com/t5/QlikView/Problem-with-Accumulated-PivotTable-2-Dims/m-p/199299#M58285 2011-04-05T22:15:13Z