topic Pivot table - Set Analysis issue in QlikView https://community.qlik.com/t5/QlikView/Pivot-table-Set-Analysis-issue/m-p/571772#M546793 <HTML><HEAD></HEAD><BODY><P> Hi,</P><P></P><P>I've got an issue with Set Analysis and pivot table</P><P>I've got a pivot table as attached</P><P>With Dimensions: Month,ID</P><P></P><P>Value of ID1 supposed to be for example: 25% (383 / 1515)</P><P>Value of ID3 supposed to be for example: 60% (917/ 1515)</P><P></P><P>My problem is to get the total value into the field calculation.</P><P></P><P>Thanks!</P></BODY></HTML> Wed, 26 Feb 2014 11:24:22 GMT 2014-02-26T11:24:22Z Pivot table - Set Analysis issue https://community.qlik.com/t5/QlikView/Pivot-table-Set-Analysis-issue/m-p/571772#M546793 <HTML><HEAD></HEAD><BODY><P> Hi,</P><P></P><P>I've got an issue with Set Analysis and pivot table</P><P>I've got a pivot table as attached</P><P>With Dimensions: Month,ID</P><P></P><P>Value of ID1 supposed to be for example: 25% (383 / 1515)</P><P>Value of ID3 supposed to be for example: 60% (917/ 1515)</P><P></P><P>My problem is to get the total value into the field calculation.</P><P></P><P>Thanks!</P></BODY></HTML> Wed, 26 Feb 2014 11:24:22 GMT https://community.qlik.com/t5/QlikView/Pivot-table-Set-Analysis-issue/m-p/571772#M546793 2014-02-26T11:24:22Z Re: Pivot table - Set Analysis issue https://community.qlik.com/t5/QlikView/Pivot-table-Set-Analysis-issue/m-p/571773#M546794 <HTML><HEAD></HEAD><BODY><P>Try</P><P></P><P>Aggr(Sum(value), Month)</P></BODY></HTML> Thu, 27 Feb 2014 13:47:38 GMT https://community.qlik.com/t5/QlikView/Pivot-table-Set-Analysis-issue/m-p/571773#M546794 alexandros17 2014-02-27T13:47:38Z