topic AGGR Function Problem in QlikView https://community.qlik.com/t5/QlikView/AGGR-Function-Problem/m-p/144787#M23611 <HTML><HEAD></HEAD><BODY><P>[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/5460.AGGRExample.doc:550:0]I have a pivot table that show SUM(Qty) by YearQuarter and WeekInQtr and would like this data to show the cummulative by Week within th the Quarter</P><P>AGGR (NODISTINCT SUM(Qty), YearQuarter, WeekInQtr)</P><P>For some reason It will work fine for YearQuarter and also by WeekInQtr but will not work correctly for YearQuarter,WeekInQtr</P><P>I have attached a sample of the pivot - I want the total units to show cummulative by Week/Quarter down</P><P>Any help would be appreciated.</P><P>Thanks</P><P>Graham</P><P></P><P></P><P></P><P></P></BODY></HTML> Sat, 23 May 2009 00:37:58 GMT 2009-05-23T00:37:58Z AGGR Function Problem https://community.qlik.com/t5/QlikView/AGGR-Function-Problem/m-p/144787#M23611 <HTML><HEAD></HEAD><BODY><P>[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/5460.AGGRExample.doc:550:0]I have a pivot table that show SUM(Qty) by YearQuarter and WeekInQtr and would like this data to show the cummulative by Week within th the Quarter</P><P>AGGR (NODISTINCT SUM(Qty), YearQuarter, WeekInQtr)</P><P>For some reason It will work fine for YearQuarter and also by WeekInQtr but will not work correctly for YearQuarter,WeekInQtr</P><P>I have attached a sample of the pivot - I want the total units to show cummulative by Week/Quarter down</P><P>Any help would be appreciated.</P><P>Thanks</P><P>Graham</P><P></P><P></P><P></P><P></P></BODY></HTML> Sat, 23 May 2009 00:37:58 GMT https://community.qlik.com/t5/QlikView/AGGR-Function-Problem/m-p/144787#M23611 2009-05-23T00:37:58Z