topic Aggr in Pivot Table in QlikView https://community.qlik.com/t5/QlikView/Aggr-in-Pivot-Table/m-p/334689#M123364 <HTML><HEAD></HEAD><BODY><P>I have a Pivot Table, and I'm using aggr with a rank function as a dimension. Here's the dimension:</P><P>aggr(rank(aggr(sum(Value),Field1,Field2,Field3,Field4),4,1),Field1,Field2,Field3,Field4)</P><P></P><P>I'm also using Fields 1, 2, and 3 as Dimensions, and I really want to aggregate on Field 4, but get a seperate ranking for each of the other dimensions. This is working ok so far.</P><P></P><P>If I want to collapse a dimension in the pivot table, it messes everything up. I assume it's because I'm aggregating and ranking by each of the dimensions. Is there a way to be able to collapse a dimension, and keep an accurate ranking within the dimensions I have open?</P></BODY></HTML> Thu, 03 May 2012 15:48:33 GMT danielact 2012-05-03T15:48:33Z Aggr in Pivot Table https://community.qlik.com/t5/QlikView/Aggr-in-Pivot-Table/m-p/334689#M123364 <HTML><HEAD></HEAD><BODY><P>I have a Pivot Table, and I'm using aggr with a rank function as a dimension. Here's the dimension:</P><P>aggr(rank(aggr(sum(Value),Field1,Field2,Field3,Field4),4,1),Field1,Field2,Field3,Field4)</P><P></P><P>I'm also using Fields 1, 2, and 3 as Dimensions, and I really want to aggregate on Field 4, but get a seperate ranking for each of the other dimensions. This is working ok so far.</P><P></P><P>If I want to collapse a dimension in the pivot table, it messes everything up. I assume it's because I'm aggregating and ranking by each of the dimensions. Is there a way to be able to collapse a dimension, and keep an accurate ranking within the dimensions I have open?</P></BODY></HTML> Thu, 03 May 2012 15:48:33 GMT https://community.qlik.com/t5/QlikView/Aggr-in-Pivot-Table/m-p/334689#M123364 danielact 2012-05-03T15:48:33Z